Thread: name formats
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Todd Taylor Todd Taylor is offline
external usenet poster
 
Posts: 1
Default name formats

Thanks Sean.....I knew It had to be easy....

"Sean Timmons" wrote:

Make sure you have some empty columns to the right of it, then highlight the
column
Data-Text to Columns
(I assume it's first name (space) last name)
select Delimited, checkmark next to space
Finish
( I assume the names were in column A)
then, go to column C
cell C2:
=B2&", "&A2



"Todd Taylor" wrote:

I'm trying to flop names in a cell from First Last to Last, First