Formula for extracting data from a string
Try:
=MID(A1,3,FIND("\",A1,3)-3)
"LFM" wrote:
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.
|