| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
extracting after a symbol
You can use functions like the following for a text string stored in cell A1:
=LEFT(A1,FIND("=",A1)-1) =RIGHT(A1,LEN(A1)-FIND("=",A1)) Hope that helps, TK "A.S." wrote: Also need help in extracting after the "=" so that the cell after will ready "AF". Thanks "A.S." wrote: what would be the correct formula to use to extract before or after a specific character. For example, if one cell has "Afghanistan=AF". I need to extract everything before the "=", so that the next cell will just read "Afghanistan". Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to insert a symbol | New Users to Excel | |||
| € (euro) symbol in Excel charts | Charts and Charting in Excel | |||
| The Mathematical "Implies" symbol | Excel Discussion (Misc queries) | |||
| how to find and replace a symbol in my worksheet | Excel Discussion (Misc queries) | |||
| I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) | |||
Threaded Mode
