| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parsing Cell Contents
I currently have a spreadsheet that that contains an email address:
. I want to create 2 new columns, one will have the first name and the second the last. All email addresses are in the format of . Can some one please help me. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Parsing Cell Contents
One way:
First Name =LEFT(A1,FIND(".",A1)-1) Last Name =MID(A1,FIND(".",A1)+1,FIND("@",A1)-FIND(".",A1)-1) HTH, Paul "metaltecks" wrote in message ... I currently have a spreadsheet that that contains an email address: . I want to create 2 new columns, one will have the first name and the second the last. All email addresses are in the format of . Can some one please help me. Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Parsing Cell Contents
With data in A1:
First name: =LEFT(A1,FIND(".",A1)-1) Last name: =MID(A1,FIND(".",A1)+1,(FIND("@",A1)-FIND(".",A1)-1)) HTH "metaltecks" wrote: I currently have a spreadsheet that that contains an email address: . I want to create 2 new columns, one will have the first name and the second the last. All email addresses are in the format of . Can some one please help me. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parsing Cell Contents | Excel Discussion (Misc queries) | |||
| parsing a cell using | | Excel Worksheet Functions | |||
| Parsing Data all in one cell that is seprated by the Enter key | Excel Discussion (Misc queries) | |||
| Parsing a alpha character out of a cell | Excel Worksheet Functions | |||
| help parsing multiple text sets from one cell | Excel Worksheet Functions | |||
Hybrid Mode
