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 |
All times are GMT +1. The time now is 08:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com