| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for extracting data from a string
long story short - because the table that has the full information is
needed for its own functions, but in another area of the speadsheet I need a table that only has the server name. On Apr 11, 5:29 pm, Gord Dibben <gorddibbATshawDOTca wrote: How about EditReplace What: \ With: nothing Replace all. If you want them both in same cell, enter =A1&" and " &A2 in an adjacent cell. Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting a string | Excel Discussion (Misc queries) | |||
| Extracting Numeric Data from a Delimited Text String | Excel Worksheet Functions | |||
| Extracting from a text string | Excel Worksheet Functions | |||
| extracting data from a text string of varying length | Excel Discussion (Misc queries) | |||
| extracting numbers from string | Excel Discussion (Misc queries) | |||
Hybrid Mode
