| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for extracting data from a string
I have a spreadsheet of UNC drive mappings. I need to extract out
just the name of the server from the fields. Example: \\SERVER01\user \\SRV02\user I need to have a cell that only reads: SERVER01 and SRV02 The data entry is consistent with the backslashes "\\" then the server name then "\" but the length of the server name can vary. I tried a MID function, but since I do not have a consistent length, I need something a bit better. If anyone can assisst me in the proper formula, I would greatly appreciate it. |
| 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) | |||
Threaded Mode
