Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
parsing field
I receive a worksheet weekly that comes with both the last
name and first initial in the same field (jones c). I would like to have the last name in one field and the first initial in another field. How would I do this? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
parsing field
Select the values
Data-Text To Columns Select the "Delimited" box <Next Select "Space" as the delimiter (and de-select any others that may get in the way (comma's for ex)) <Next etc. This will split the names for you. Depending on the makeup of the names you may have to do some "playing around" If, for ex, the last name has a space in it, then XL will parse it on the first delimiter it finds, which will split the last name. Read the Help on the subject -- Regards; Rob Please reply to the NG, I'm already up to my eyeballs in Nigerian/South African get rich letters as well as "Microsoft Critical Updates" et al. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
parsing field
Make sure the column to the right is blank (or insert a column)
select the column with the data and do Data=Text to Columns Select delimited and space as the delimiter. If you have last names with embedded spaces, this will not work. You could use a formula B2 C2 =trim(left(Trim(A2),len(trim(A2))-1)) =Right(Trim(A2),1) drag fill the formulas down the column. Regards, Tom Ogilvy ccj wrote in message ... I receive a worksheet weekly that comes with both the last name and first initial in the same field (jones c). I would like to have the last name in one field and the first initial in another field. How would I do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parsing Out a Month from a date field | Excel Discussion (Misc queries) | |||
Parsing Last Character in variable length text field | Excel Worksheet Functions | |||
Parsing excel field help ! | New Users to Excel | |||
Instead of Parsing | Excel Discussion (Misc queries) | |||
parsing a date field | Excel Discussion (Misc queries) |