cuting some text from field
 

Hi,

I need some basic script that will allow me to separate text, after "@"
sign from textfield.
For example I have .
I need "company-****ry" to be placed next to the e-mail adres in the
excel spreadsheet.

A B
company-country
company-country2
......

I have over 1000 e-mail adreses so I need some script to do this. Last
time I had only 60 so I made that by my own :).

But 1000 e-mail adreses is too much for me :)

Thanks for help

--
ukash

cuting some text from field
 

You can do this with formulas. This will get you the data after the @ sign:

=MID(A1,FIND("@",A1)+1,255)

To get rid of the .com, you can use the left function:

LEFT(B1,LEN(B1)-4)

Or one large formula:

=LEFT(MID(A1,FIND("@",A1)+1,255),LEN(MID(A1,FIND(" @",A1)+1,255))-4)


You can use the same logic with code.

"ukash" wrote:

Hi,

I need some basic script that will allow me to separate text, after "@"
sign from textfield.
For example I have .
I need "company-****ry" to be placed next to the e-mail adres in the
excel spreadsheet.

A B
company-country
company-country2
......

I have over 1000 e-mail adreses so I need some script to do this. Last
time I had only 60 so I made that by my own :).

But 1000 e-mail adreses is too much for me :)

Thanks for help

--
ukash

cuting some text from field
 

Damon Longworth wrote:
You can do this with formulas. This will get you the data after the @ sign:

=MID(A1,FIND("@",A1)+1,255)

To get rid of the .com, you can use the left function:

LEFT(B1,LEN(B1)-4)

Or one large formula:

=LEFT(MID(A1,FIND("@",A1)+1,255),LEN(MID(A1,FIND(" @",A1)+1,255))-4)

Thanks :)
You have helped me a lot :)


--
ukash