Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mail Merge/Data Entry question
Liz
I suspect it's not as simple as this as names seldom are, but if they are, highlight them and go to DataText to columns..., use delimited on the first screen,comma on the next and finish. This will separate them into two columns based on the comma Post back if, as I suspect, it's not quite as simple as your example -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Liz-In-USA" wrote in message ... I have "inherited" a spreadhseet with about 350 names & addresses that's being used for a mail merge. If it is currently set up with last name & first name in the same cell, is there a way to "train" or program Excel so that they are in two separate cells? For example: What I have: Smith, Brad (all in one cell w/header NAME) What I want: Smith (in one cell w/header L_NAME) Brad (in separate cell w/header F_NAME) thanks, Liz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge question | Excel Discussion (Misc queries) | |||
Why does my excel to word mail merged doc not merge last entry? | Excel Discussion (Misc queries) | |||
Another Mail Merge Question | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) |