Excel Remove Specific Text From Cell

) I can move around the "comment" but cannot delete it. Excel Formula Training. In Excel, there is a tool we’re going to use called Text to Columns. You can count the number of cells which have text but not actual words in them. How to Count Specific Characters in an Excel Cell A useful trick is to be able to count the number of times a specific character exists in a text string. How do I remove certain character from a cell with a formula in Excel 2013/2016. In this example we will see how to delete the rows in excel worksheet using VBA with specific value. e cells that begin with any of DOG, Dog, DoG or dog will all be deleted. Delete Row With Specific Word. Delete instead. this is for second column: the value required is between Data and Policy. After you do so, Excel deletes the empty rows. I need either a formula or a Macro to delete these texts from the Cells. VBA to delete row if column does not contain a certain value the rows that do NOT contain a certain text. Result: See also: Excel VBA, Create Border. LineStyle _ = xlNone. Without changing anything, press Ctrl+Shift+Enter. I have found the quickest way to delete just the numbers form my Excel cells is to use the GoTo Special Command. I need a code for filtering the cell's content. eventually in my VBA code i get it to text to columns it. Check to ensure that it is correct. Excel can perform two kinds of cell deletions in a worksheet: clearing cell data and deleting the cell. And if the list contains more than eight cells, Excel adds a scrollbar to the dropdown list box. In the example shown, the formula in C6 is: = REPLACE ( B6 , 1 , 24 , "" ) How this formula works The replace function lets you replace text based on its location. Question: How can I delete a hyperlink in Microsoft Excel 2016? Answer: In this example, we have a hyperlink in cell A3 that we want to remove. I am looking for a macro to remove the period from the cell. The TRIM function in Excel can be used to get rid of excess spaces in a text string. Or how to delete all rows that contain certain value with VBA code in excel, such as, removing all rows if cell contains 0 or any other value. Simple Methods to Copy Excel Formula Values LAST UPDATED: November 28, 2019 By Anne Hennegar Recently I was watching an Excel product review and noticed the author copy Excel values from a formula into another column. For example. Highlight or select a range of cells. I have the same question (26) Subscribe. For instance I look-up the following in cell A2 Application: sales_rep_support and use find =RIGHT(a2,FIND(" ",a2)+4) to change it to sales_rep_support. Excel vba insert rows based on cell value - Forum - Excel Excel vba select row based on cell value - Forum - Excel This document, titled "Excel/VBA - Deleting a string of character in a range of cells," is available under the Creative Commons license. For example if you need to delete rows with someone's name, type that name in. You can also use the IF and the COUNTIF function in Excel to check if a cell contains specific text. In this post we’re going to explore how to find and remove multiple text strings from within another string. To remove all smart tags that are associated with a specific recognizer, follow these steps:. Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets. I want to remove the first line in every one of those cells and leave the rest of the lines. NET: Description: This example shows how to write data into an Excel workbook in Visual Basic. It removes all spaces and in-between spaces except for a single word or space character. Clipboard: A holding place for cut or copied text. Here's How to Find and Remove Specific Duplicate Data on Excel Using Conditional Formatting. If you're working with numbers in a column, you can highlight the whole column by. 5) which is the third out of four items in the string. The add-in is included in our Text Toolkit for Excel that contains 8 useful add-ins to manage text data in Excel (remove extra spaces, substrings and non-printable characters, change case, split cells, etc. However I run into problems because I have other values that need parsed such as. This will help you to know how to delete specific rows based on a cell value from Excel workbook using VBA. The following code sample is used to delete text from a specific cell in a spreadsheet document. Every time the value in this cell changes, SAS reads in the new value and outputs the observation to a data set. Copy and paste this table into …. I've been having some fun recently playing around cleaning up an excel document, it needed to be automated as a new document is created every day. Please feel free to state your query or feedback for the above article. r/excel: Discuss and answer questions about Microsoft Office Excel if cell contains certain text then return value of another cell? solved. If a column that you want to sort contains both numbers and text—such as Product #15, Product #100, Product #200—it may not sort as you expect. VBA code to delete row if cell contains string value example will help us to delete rows if cell contains specific word, text or value from excel worksheet. Remove Unwanted Characters If you want to remove unwanted or specified characters from a text string, you can create an excel formula based on the SUBSTITUTE read more ». Re: Remove or Delete Part of Cell Text. Hello, Remove Specific Characters From Text Cell - Excel. View an alphabetical listing of Excel Tech Tips. Here's an Excel macro that will delete all the rows that contain the specified word in the column that you set it to search. PS: As I was traveling in last 2 weeks, I could not write often. Excel 2008 (Mac) Excel. Also, when you click in a cell, if there is a cell name associated with that cell, it will display in the name box as shown in the worksheet image below. The period can be found in any position in the cell, but typically appears as the first or the last character. Then select red color in the font color option. Now, you want to have cell A2 display the text "Today's sales are $12,000", where $12,000 is the value calculated in D2. If you don’t want to merge the cells, you can still center text across them. I need the code amended so that it looks if a cell contains "Transfer" even if there is other text in the cell e. First, highlight the text. You can delete the text before or after a certain character several different ways in Excel. How to Remove […]. i need to ask if you there is something in excel where you can find a specific word in a cell and delete that but keep the other words or character in place. [num,txt,raw] = xlsread(___) additionally returns the text fields in cell array txt, and both numeric and text data in cell array raw, using any of the input arguments in the previous syntaxes.  To remove other leading zeros from this text, I extend this formula to the right-side cells (up to J column as at most 9 leading zeros can be in a text). I received an email asking how put these text together. Thanks for reply venkat1926, But I have a list of texts need to be searched in other text and removed. Borders(xlDiagonalDown). Value) Then. VBA code to delete rows based on cell value Here is the Example VBA syntax and Example VBA Macro to delete rows from excel worksheets based on cell value. How to remove Characters from fields in Excel, remove characters from the middle of cells of data. Re: excel macro for find and delete specific data. You can also use the IF and the COUNTIF function in Excel to check if a cell contains specific text. Excel wraps the text in the cell. This is easy to do this with Excel's built-in Find and Replace. In cell B2, I use this formula: =IF(LEFT(A2) = “0”, RIGHT(A2, LEN(A2)-1), A2) This formula will remove the first leading zero from the text. Today we will learn a very simple trick to delete blank rows from excel spreadsheets. Deleting cells leads to blank rows or columns, and if either of these are in the wrong place, it could impact some of Excel's more powerful features. Click the information displayed in the formula bar. Note the use of Ucase means that the formulae is case INSENSITIVE i. With the Remove by Position utility of the third party add-in Kutools for Excel, you can be easy to remove first, last or certain characters from the text string. Remove empty rows & columns by using these simple tricks. Click the Merge and Center button on the toolbar. If a column that you want to sort contains both numbers and text—such as Product #15, Product #100, Product #200—it may not sort as you expect. Add the IF function. So I have a range of data spanning A2:AK2000 and I'm trying to get the macro to scan column U, and then delete the entire row whenever it sees anyone of 5 possible words. The formula is. Active 7 years, 3 months ago. We are going remove blank cells from this table. Learn How to Remove blank rows in Excel. Any ZZ+number should remain together with the number in the left. You cannot assign a value to this property. Learn more. PS: As I was traveling in last 2 weeks, I could not write often. Arrows in the column headers appear. A big part of cleaning up data is removing spaces in cells with text. How To Delete Cell Content In Excel With Simple VBA I only want to keep the information in that specific column for the first row of the group and delete the other information in that column for the other rows in the group. Borders(xlDiagonalDown). Removing a word from cells in Excel doesn't require you to erase all content within the cell in question. Click in the formula bar or press F2. It is not a text to column formula, it’s a wizard which works on click. Excel only permits deletion of one character or word at a time. In the example shown, the formula in C4 is: How this formula works. How to use Substring functions in Excel to extract text from cell, get a substring before or after a specific character, find cells containing part of a string (partial match), and more. Fill tool: Takes the data from the first cell in a selected range and copies it to all of the other cells in the selection. If you go to Excel Options > Advanced > Lotus Compatibility > Check select transition navigation keys > OK and return to your data you will see that Excel will show the selected cell to be left aligned. Remove Empty space without affecting data. I've seen where you can do it with individual cells, but not looping through the whole spreadsheet. Delete 'Change. So I have a range of data spanning A2:AK2000 and I'm trying to get the macro to scan column U, and then delete the entire row whenever it sees anyone of 5 possible words. [num,txt,raw] = xlsread(___) additionally returns the text fields in cell array txt, and both numeric and text data in cell array raw, using any of the input arguments in the previous syntaxes. Worksheet Name: Have a worksheet named Analyst. This site uses cookies for analytics, personalized content and ads. I have, what LOOKS like a comment box containing text on my excel. Lets say we want to delete pictures in specific Cells, only pictures in Range E2:E9. In this example we will see how to delete the rows in excel worksheet using VBA with specific value. We can use Delete method of Columns to delete the Columns if the cell value matches the given string. This step by step tutorial will assist all levels of Excel users in removing text based on their position using two different methods. In this case, if the text in the name cell starts with * or #, remove it. Re: Split Cells based on the words that appear. I have an excel file that has data dumped from external source (P6). Macro to delete cells with specific text? unsolved. For example, you may have a cell that contains a combination of text and numbers, or a cell that contains two numbers separated by a delimiter such as a comma. Home » How To Delete Cell Content In Excel With Simple VBA. To delete data that already appears in a cell: Click the cell containing the information you want to delete. A simple method to select a range of cells given certain criteria. I hope you understood how to remove unwanted characters from the text using SUBSTITUTE function in Excel. If you want to remove cells from the worksheet and shift the surrounding cells to fill the space, you can select the cells and delete them. In order to remove rows containing the “delete” text. txt file with matlab into a cell array table. The data is riddled with "na" where the supplier of the data sometimes leaves it blank, like they should, but instead sometimes puts in · >>then where it says "international" it will say. Sub DoTrim() Dim LastRow As Long Dim cell As Range. How to remove a specific string of text, IF it appears, and copy the remaining text to the next cell over. While working with Excel, we are able to remove specific parts of a text string by using the REPLACE or SUBSTITUTE functions. Count, "U"). Re: Remove or Delete Part of Cell Text. example, each cell value in A represents a medium such as a radio station, and the values in B represent the ratings, and C represents a ranking etc. The SUBSTITUTE function can find and replace text in a cell, wherever it. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. This causes problem when you filter, match table, join (merge), or find duplicates. If the text you wish to recover is always after the # symbol you could use this formula, replacing the reference A1 with the reference to the cells you need to copy =RIGHT( A1 ,LEN( A1 )-FIND("#", A1 )). Thanks for reply venkat1926, But I have a list of texts need to be searched in other text and removed. So I have a range of data spanning A2:AK2000 and I'm trying to get the macro to scan column U, and then delete the entire row whenever it sees anyone of 5 possible words. Select the cell or range of cells that contains the formula. While working with Excel, we are able to retrieve only the specific parts of a text string that we want by using the REPLACE, RIGHT or LEN functions. Now we know that the above explained Cells() method takes parameters. Excel VBA delete all pictures in specific Cells. Arrows in the column headers appear. If you're working with numbers in a column, you can highlight the whole column by. Remove gridlines for specific cells With Excel 2010, how can I remove the Gridlines for specific cells? Thanks, / Gary E. A very common problem is how to remove numbers from text cells in Excel. I have an Excel spreadsheet with a column in it that contains multiple lines in each cell. Otherwise, keep the contents intact. REPLACE used in a standard macro on Preselected Text Cells (#macro) For assistance in installing the following standard code macro see Getting Started with Macros. To merge a group of cells and center the text, you can also use the Merge and Center button on the Excel tool bar. ",A1) - 1) & RIGHT(A1, LEN(A1) - SEARCH(". Excel is packed with many features, including one called Speak Cells, which basically lets you feed your chosen cells to a text-to-speech engine. We can use Delete method of Rows to delete the rows if the cell value matches the given string. The "ReadExcelCell" method read the data in an Excel cell. In the second wizard, check a Delimiters box 4. VBA code to delete row if cell contains string value example will help us to delete rows if cell contains specific word, text or value from excel worksheet. Tagged as: Excel Data Validation, Excel Lists, Excel range names. If cell contains text, then remove this text Register for a FREE account, and/ Excel Version Excel 2010. Remove Specific Characters From Text Cell. Write data into an Excel workbook in Visual Basic. Microsoft ISV Community Center > Visual Basic for Applications (VBA) If I find that phrase, delete all rows from Row 1 down to and including the row with the phrase. A key difference with the Data Bar format is it shows on all cells as opposed to ones that meet a specific condition. In a column on the sheet is a transaction description in text. I tried this but no luck: Sub Test() Dim Rng As Range Dim x As Long Set Rng = Range("A1:A" & Range("A65536"). Have you ever faced a situation where you have to rank values by using some specific [] Remove First Character: To remove first or n characters. For example, 78 will become '78 which will force Excel to treat the number as text. The period can be found in any position in the cell, but typically appears as the first or the last character. VBA code to delete rows based on cell value Here is the Example VBA syntax and Example VBA Macro to delete rows from excel worksheets based on cell value. Can you help?. Thread starter su2009; Start date Sep 24, 2010; S. Feel free to install a fully functional 7-day trial version of Text Toolkit to see the add-ins work. You could use Ctrl-H (find and replace). Otherwise, keep the contents intact. In this case I was looking at keywords related to a specific type of content marketing. To remove specific unwanted characters in Excel, you can use a formula based on the substitute function. right after i enter that formula it highlights a bunch of cells. Remove Specific Characters From Text Cell I would like to create a formula that removes a specific character if it appears in a cell. If you have installed Classic Menu for Office, you can go back the familiar classic menus and toolbar interface of Excel 2003/XP(2002)/2000 on the ribbon of Excel 2007/2010/2013. I want to delete the cells (not the entire row) that have '-' in them, and have the remaining cells move up, so that it results in a list of names with no blank cells or '-' cells in-between. Choosing the right method mostly depends on what your data looks like. Excel only permits deletion of one character or word at a time. Wrap Text and Remove Wrap Text from Cells using VBA. 79025555518 79025555619 79025555720 After the values are changed I am trying to add two hyphens. This is easy to do this with Excel's built-in Find and Replace. The SUBSTITUTE function lets you replace text by matching content. With this utility you can remove or replace certain characters in your worksheet or selected cells. Excel enables you to apply formatting to cells that meet certain criteria that you specify. In the example shown, the formula in C4 is: = SUBSTITUTE (B4, CHAR (202), "") Which removes a series of 4 invisible characters at the start of each cell in column B. VBA – Delete / Remove rows from a specific worksheet in Excel Posted on April 2, 2018 by Vitosh Posted in VBA \ Excel Imagine one of the most trivial tasks in Excel – remove rows from Excel, for which contain the number 1 in their first column. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string. All you need to do next is select Constants and un-check everything EXCEPT the numbers option. LineStyle _ = xlNone. In this two-part tutorial, learn how to pull text from cells & separate them into multiple columns in MS Excel. Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets. VBA code to delete row if cell contains string value example will help us to delete rows if cell contains specific word, text or value from excel worksheet. Choose the Home tab. This article describes the formula syntax and usage of the SUBSTITUTE function in Microsoft Excel. "Transfer date" ot "transferring". I'm trying to write a macro in Excel for inserting input text to a specified cell. This post will guide you how to remove a specific character from text cell in Excel. 5 South' you may wish to extract the number (23. The wrapped text feature wraps the contents of a cell across several lines if it's too large than the column width. Any help will be highly appreciated. Thanks for reply venkat1926, But I have a list of texts need to be searched in other text and removed. Remove unwanted characters. › [Solved] how to bold text in an excel formula › Formula to enter text in one cell based on text in another? › [Solved] Need An Excel Formula To Determine Vacation Days › [Solved] Is there a way to skip lines in an array formula calendar › How to change text in a cell based on value i › [Solved] What is the term to use in an IF. How to split text into multiple cells in Excel Kawser December 26, 2013 993 no comments When you import data from another source, it may happen that multiple values have been imported into a single column. Sometimes you need to search for a specific piece of text within a cell. *How Can I Find Out The Length Of My Text in Excel. It is not working when I try to copy visible cells which i filtered. I have a massive list of email addresses; but just to make things simple i am dealing with 3 - 10 email addresses that are typed up in 1 cell and i cant seem to MASS delete specific ones. We can use Delete method of Rows to delete the rows with specific value. I have already an InputBox specifying the text to be put in and an inputbox specifying which row to insert the data. How Excel Multi-Cell Array Formulas Work. Count, "U"). It requests that excel removes the hyphen (text to remove) and the inverted commas serve as the new text without the hyphen that has been removed. View an alphabetical listing of Excel Tech Tips. I'd also like to know how to delete to delete the code in cell F2 that appears in cell C2. Sometimes we need to remove extra characters which come in excel cells. vba delete entire row if contains certain text in Excel Cells(i, "A"). I have a range of text data in the following format: Sample cell a1= "textstring (tag1)(tag2)(tag3)" I need a formula that would output the value of cell a1, EXCEPT for any additional tags that are attached to the textstring. I use Excel to list my inventory for an online auction site. If you want to remove cells from the worksheet and shift the surrounding cells to fill the space, you can select the cells and delete them. example, each cell value in A represents a medium such as a radio station, and the values in B represent the ratings, and C represents a ranking etc. Question: How can I delete a hyperlink in Microsoft Excel 2016? Answer: In this example, we have a hyperlink in cell A3 that we want to remove. Remove From My Forums; Answered by: Ignore certain text in a cell. Click the Find All button. This post will guide you how to remove a specific character from text cell in Excel. There is no constant for the number at the beginning of the cells. The formula is. The easiest way on how to split Cells in Excel or split Columns in Excel, is to select the column you want to split. Formula breakdown: =SUBSTITUTE(text, old_text, new_text, [instance num]) What it means: =SUBSTITUTE(This cell, By this text character, To this text character, [In the 1st, 2nd…instance it occurs]) There are times where I needed to remove the nth. Another way to quickly remove indentation, and any other formatting, in Excel 2013 is to use the Clear Formats option. LEFT: Returns the first character(s) in a text string based on the number of characters specified. It may be helpful for you to write down all the different punctuations and all capitals you wish to delete so you can cross. However I run into problems because I have other values that need parsed such as. Microsoft Excel 2002 and later versions of Excel delete cells in a "For EachNext" loop in a different way than Microsoft Excel 97 and earlier versions of Excel do. A simple method to select a range of cells given certain criteria. Highlight the cells with leading zeros. 5) which is the third out of four items in the string. Please feel free to state your query or feedback for the above article. How to Truncate Text in Excel. You can use a formula like this to strip the last 3 characters, last 5 characters of a value, starting on the left. ClearComments For Each cell In Intersect (Selection,. For example, you can use CLEAN to remove some low-level computer code that is frequently at the beginning and end of data files and cannot be printed. Remove text after a specific character. Excel will display the Delete dialog box, with the Delete Cells Up option selected. To remove whitespace in a long list of cells, copy the Trim or Substitute formula by dragging its bottom-right drag bar down the formula column. VBA Delete rows based on cell value: Syntax. The default setting is to treat blank cells by placing gaps in the chart. Can a macro be written to look for these 35 text items and delete or clear the row? Running MS Excel 2010 Windows IE 8. vba delete entire row if contains certain text in Excel Cells(i, "A"). This will help you to know how to delete specific rows based on a cell value from Excel workbook using VBA. In this case, if the text in the name cell starts with * or #, remove it. Then use Fill Down so Excel adjusts the A1 reference for all the other rows. In the example shown, the formula in C4 is: How this formula works. The following option box appears on the screen. Select the check box to indicate if your data has headers. In this post we’re going to explore how to find and remove multiple text strings from within another string. In this lesson, I'll show you have to achieve this with a single click, instead of using all these steps. Excel 2008 (Mac) Excel. VBA code to delete Columns if cell contains string value example will help us to delete Columns if cell contains specific word, text or value from excel worksheet. For instance: First I would like to insert the text, Budget, into cell B5. Using REPLACE Function to Remove First Character from a Cell And if you want to use a single formula, you can use REPLACE function. This article will teach you a foolproof way to remove cell formatting from an Excel document. Discussion: In our sample, the criteria is the minimum and maximum values that you would like the cells to have. this is for second column: the value required is between Data and Policy. Formulas are the key to getting things done in Excel. Of course, the cell reference may differ. r/excel: Discuss and answer questions about Microsoft Office Excel if cell contains certain text then return value of another cell? solved. For example if each data record (or row) looks something like 'A100 John 23. The code above will loop through each cell in a selected range and apply the VBA Trim function to the value inside the cell. To do this, select the cells you want to merge. A very common problem is how to remove numbers from text cells in Excel. Otherwise, keep the contents intact. For example, you can use CLEAN to remove some low-level computer code that is frequently at the beginning and end of data files and cannot be printed. Fill handle: Black box in the bottom right corner of a cell or a range of cells. How do I remove certain character from a cell with a formula in Excel 2013/2016. Here is what 5 cells looks like: SEA-MVRV, SEA-RAD SEA-MVAOV, SEA-OPSSRO SEA-MVAOV1 SEA-CRNPOLAR, SEA. The data is riddled with "na" where the supplier of the data sometimes leaves it blank, like they should, but instead sometimes puts in · >>then where it says "international" it will say. Getting Rid of Extra Spaces Between Sentences and Paragraphs. The video offers a short tutorial on how to remove selected part of text from some or all the cells in Excel. How do I remove unwanted characters from a cell using Excel formula. For example, 78 will become '78 which will force Excel to treat the number as text. DOWNLOAD OUR FREE EXCEL RESOURCE GUIDE E-BOOK! What does it do? Substitutes new_text for old_text in a text string. Any ZZ+number should remain together with the number in the left. For example mystring="site, site text, sales " I want to remove 'site' from mystring. you can then drag your cursor over the cell range to select it and Excel will insert D1:D12 into the formula. The reason why we need this enumerator is that when an Excel cell is empty, the cell simply does not exist in the Open XML. In the first Convert Text to Columns Wizard , select Delimited option, 3. Move the active cell (that's the cell currently selected) to the start of the range of cells you want to select. these formulas help me lot while i am working in spreadsheets. , column A) in alphabetical order. Row For i = Last To 1 Step -1. I have an excel file that has data dumped from external source (P6). How to Split Text String by using Functions in Excel. Text cells are are sorted in ascii collating (sorting) sequence left to right (spaces included), and numeric cells are sorted as a group numerically before the grouping of text cells. Can you help?. Occasionally you need to convert a specific string to remove some x number of characters at the beginning of the string. In Excel, counting cells that contain specific text is an important task. One example I had to deal with in my professional career was a situation where a workbook combined invoice and credit note data from two different systems. Additional Find Options The Excel Find command can be refined using a number of options, which can be displayed by clicking on the Op t ions >> button in the Find and Replace dialog box. How to delete a certain string from every cell in Microsoft Excel. Remove Empty space without affecting data. I want to remove the usernames (everything starting with a "@") and I also want to remove the web-link (the "https:xxxxxxxxxxx"), and I want to end up with this in the cell: nope just Stranger Things Season 2 or Ready Player. I want to delete the cells (not the entire row) that have '-' in them, and have the remaining cells move up, so that it results in a list of names with no blank cells or '-' cells in-between. Is there a way to delete part of the information from a cell (overlapping in the adjacent cell)? Example: H78646733 from cell C2 can be found at the end of the text in cell F2 (Hamilton Khaki Belowzero Men's Watch H78646733). For example a cell could look as follows: This pair of binoculars is fantastic. Type the text that is contained in the row you wish to delete. I would like to delete all rows which do not have that word in them, leaving Microsoft Excel MVP. In the produce spreadsheet, for example, your program could apply bold text to the potato, garlic, and parsnip rows. To remove a cell name or simply change it, you must use the Name Manager menu item under the Formulas tab: This will open the following page that reports all the cell’s names allowing you to delete or change their names: Choosing a name in the list, you can modify it simply clicking on the Edit or Delete button. Looking into the sharedstrings. How do I delete specific text in multiple cells at once? Ask Question Is there any way I can delete a specific email address from the cell, Additional Info: I am using Excel for Mac 2011. For instances like these, use the LEFT function to remove unwanted data when the good data is on the left side of the unwanted characters in the cell. Removing a word from cells in Excel doesn't require you to erase all content within the cell in question. Format : Cells(Row,Column) Excel is represented in a grid format, tabular form in rows and columns, so to reach to particular cell you need tell to compiler the cell is located in which row and which column in that particular row. I need the code amended so that it looks if a cell contains "Transfer" even if there is other text in the cell e. Related Articles: How to Remove leading and trailing spaces from text in Excel. Excel can perform two kinds of cell deletions in a worksheet: clearing cell data and deleting the cell. Excel VBA to delete rows if specific Text is found in column A I have a sheet that is assembling data from a variety of other sheets. Delete Text In Cell After A Specific Symbol Jan 9, 2009. Read this post to findout how to delete blank rows / cells from your excel data in a snap. This formula is the command that locates and selects specific text. After that just hit the Delete key to remove the values.