| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I format list of names formatted last,first to first la
THANK YOU SO MUCH, THIS WAS A LIFE SAVER!! I KNEW THERE HAD TO BE A WAY,
EXCEL CAN DO A N Y T H I N G !! Thanks all for your assistance, I'm telling my friends about this website. Again, you're a life saver. MERRY CHRISTMAS!! "Ron Coderre" wrote: See if this works for you... Try DataText-to-Columns Set the delimiters to comma and space That should break the text into 2 columns. Does that help? *********** Regards, Ron "RenieFo" wrote: ANYONE KNOW, OTHER THAN CUT AND PASTE, A METHOD OF "flip flopping" names in a list, from last, first to first last? (maybe "telling"the list to separate into 2 columns the words separated by the comma, last in one column and first in another). I have a list of 360 names and not looking forward to cut and paste this list. HELP! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
| How do I import a list of names into a separate form that prints . | Excel Worksheet Functions | |||
| How do I create/filter a list of names without duplications | Excel Discussion (Misc queries) | |||
| How do I find a name in a list of names? | Excel Worksheet Functions | |||
| List of repeating names | Excel Worksheet Functions | |||
Threaded Mode
