Try this:

=MID(B4,FIND("@",B4)+1,LEN(B4)-FIND("@",B4)-4)


"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