Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date field from text field | Excel Worksheet Functions | |||
Trouble sorting first by a dates field and then by a text field. | Excel Discussion (Misc queries) | |||
Changing a text field to a date field | New Users to Excel | |||
How to keep leading zero without changing field to text field? | Excel Discussion (Misc queries) | |||
HELP!! Populate text in single XL field, or bulk copy text into 1 field | Excel Programming |