Search : in
By :

Removing specific characters from a cell

Last answer on Jul 29, 2009 11:04:17 am BST Dave, on Jul 29, 2009 2:55:40 am BST 
 Report this message to moderators

Hello,

I am trying to find out how to remove a word and a character from a cell that contains text. Say if the Cell values has "ALBERTSONS LLC DALLAS - RMA", i want the output to be just "ALBERTSONS LLC DALLAS", so i want to remove the letters "RMA" and the "-" as well. Sometimes the cell value could be
"ALBERTSONS LLC DALLAS-RMA", with no space between the hyphon sign and the letters. Is there a way around this to get the desired output using a formula?

Thanks
Dave

Configuration: MS Office Excel 2003

Best answers for « Removing specific characters from a cell » in :
Characteristics of programming languages Show There are many programming languages, each corresponding to specific needs (formula calculus, character string processing, real-time, etc.) with each having specific characteristics and functionalities. Therefore, the choice of programming language...
File names having special characters Show
Escape an apostrophe under javascript Show Escape an apostrophe under javascript In Javascript, an apostrophe (single quote) into a string itself enclosed by apostrophes cause an error. To troubleshoot, you should escape the apostrophe by heading the backslash character to get...
[PHP]Clean up a string Show[PHP]Clean up a string Here's a function in PHP which can be quite handy, especially when doing the URL rewriting. This function transforms the characters of any string in unstressed chain, removing special characters and replacing...
Permanently delete files from trash bin ShowPermanently delete files from trash Sometimes when emptying the trash some files stays and refused to be deleted! You just have to use a command: Start the Terminal - Type "sudo rm • • •-R" - Drag files, folders that you want...
[VBA] Deleting a word in a range of cell Show[VBA] Deleting a word in a range of cell In the case you want to delete a word in a sentence, just create a small macro that removes the word. But it will become difficult when you have word like, for example, "Theword" or "THEWORD" or...
CSS - Style sheets ShowFont properties Property Value Description font-family Specific font (Arial, Times, Verdana) Familly (serif, sans-serif, fantasy, monospace, cursive) Defines one or more font names or font families. If multiple fonts are defined,...
Special characters ShowSpecial character codings HTML standards require all code to be written in 7-bit ASCII, which means that accented characters are not allowed. Despite this, current browsers recognise accented characters; you can enter accented characters directly...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

 venkat1926, on Jul 29, 2009 11:04:17 am BST
  • +1

If the string is in A1 try this formula

=MID(A1,1,SEARCH("-",A1)-2)&""""

But I wonder why do you want the double quote

   
Reply to venkat1926
Ask your question Reply
They need your help