Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reverse name order from Last, First to First Last in Exc
I received a file from an outside vendor with names listed Last, First. I
need to print labels for mailing from this file with names First Last. Is there a way to reverse the order in an Excel spreadsheet? |
#2
|
|||
|
|||
Answer: How do I reverse name order from Last, First to First Last in Exc
Yes, there is a way to reverse the order of names from Last, First to First Last in Excel. Here are the steps:
That's it! You can now use the new column with the reversed names to print your mailing labels.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reverse name order from Last, First to First Last in Exc
=MID(A1 & " " & A1,FIND(" ",A1,1),LEN(A1))
-- Gary's Student "Annie Lord" wrote: I received a file from an outside vendor with names listed Last, First. I need to print labels for mailing from this file with names First Last. Is there a way to reverse the order in an Excel spreadsheet? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reverse name order from Last, First to First Last in
Thank you so much!! That saves me enormous amounts of time. A
"Gary''s Student" wrote: =MID(A1 & " " & A1,FIND(" ",A1,1),LEN(A1)) -- Gary's Student "Annie Lord" wrote: I received a file from an outside vendor with names listed Last, First. I need to print labels for mailing from this file with names First Last. Is there a way to reverse the order in an Excel spreadsheet? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reverse name order from Last, First to First Last in
You are very welcome.
-- Gary''s Student "Annie Lord" wrote: Thank you so much!! That saves me enormous amounts of time. A "Gary''s Student" wrote: =MID(A1 & " " & A1,FIND(" ",A1,1),LEN(A1)) -- Gary's Student "Annie Lord" wrote: I received a file from an outside vendor with names listed Last, First. I need to print labels for mailing from this file with names First Last. Is there a way to reverse the order in an Excel spreadsheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reverse column order with a macro | Excel Discussion (Misc queries) | |||
Is it possible to print the pages of a workbook in reverse order? | Excel Discussion (Misc queries) | |||
How do I quickly reverse the order of a set of data | Excel Discussion (Misc queries) | |||
How 2 reverse order of columns | Excel Discussion (Misc queries) | |||
how to paste the values in reverse order in workbook | Excel Discussion (Misc queries) |