Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks again for all your help. This group has been quite valuable to
me. There are a couple of things I would like to do here. First, I have two columns of data. Col B is last names, Col C is first names. I would like to combine all that data into Col B with the Last Name First, (comma space) then First Name. Is there a quick macro I can write to do that? Then, after the data is in that format, is there a way to reverse column B so that the data is First Name First (space) Last Name (no comma)? That would be the best. I need the data both ways at different times depending on what I'm doing. Thanks again in advance for the advice. JasonK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combine titles/names - how? | Excel Discussion (Misc queries) | |||
Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
How can I combine cells with first/last names into email addy? | Excel Worksheet Functions | |||
Combine several Names in one folder with if-formula | Excel Discussion (Misc queries) | |||
how do I combine cells (names) | Excel Discussion (Misc queries) |