Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting and Extracting data
I really hope someone here can help me. I have imported text into excel which is currently in A1-A4600; quite a bit of info. The data previously looked like this: ST last name, first name STORE# ADDRESS CITY ZIP Phone I was able to get the ST (state) in column A, and the last name in column C by using the text to column function. In column C, I need the first name. This data can be any length, contain a nick name or middle inital so it would have to extract all the text up to the first number for the store number. Can someone help me out on this one? -- JaredC ------------------------------------------------------------------------ JaredC's Profile: http://www.excelforum.com/member.php...o&userid=36497 View this thread: http://www.excelforum.com/showthread...hreadid=562544 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting and Extracting data
You might try the delimited and check the box with space, depending on the
type of data "JaredC" wrote: I really hope someone here can help me. I have imported text into excel which is currently in A1-A4600; quite a bit of info. The data previously looked like this: ST last name, first name STORE# ADDRESS CITY ZIP Phone I was able to get the ST (state) in column A, and the last name in column C by using the text to column function. In column C, I need the first name. This data can be any length, contain a nick name or middle inital so it would have to extract all the text up to the first number for the store number. Can someone help me out on this one? -- JaredC ------------------------------------------------------------------------ JaredC's Profile: http://www.excelforum.com/member.php...o&userid=36497 View this thread: http://www.excelforum.com/showthread...hreadid=562544 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
splitting worksheet by column entries | Excel Discussion (Misc queries) | |||
Splitting Up Text in One Cell To Many | Excel Worksheet Functions |