One way, assuming there may be "." in the server name that you want to
keep:

=MID(LEFT(A1, FIND("^^", SUBSTITUTE(A1, ".", "^^", LEN(A1) -
LEN(SUBSTITUTE(A1, ".", "")))) - 1), FIND("@", A1) + 1, 255)

In article ,
Eelinla wrote:

Hi, I am trying to move data from one column of a chart to another.
For example:

cell B4 =
cell C4 =
cell D4 =

what i need to do is pull the servername out and move it to the
corresponding cell ie B6, C6, and D6

ex of what i want in cell B6 = blah
ex of what i want in cell C6 = wee
ex of what i want in cell D6 = anotherlongname

I have tryed various combinations of string formulas and the closest i could
get still left me with more information than i want as the data in column B
varies in length.
I have tryed various ways using the find mid right left to no avail. Any
help would be appreciated.

~Thanks Eelinla