Field Format

  • Thread starter Thread starter N Sabo
  • Start date Start date
N

N Sabo

I have a column of name data in the format of "First Name Last Name". Does
anyone have a script that will change all the entries in this column to
"Last Name, First Name" ?
 
suggest copy name list to a blank workbook follow the steps then paste
name list back into original list

One option without using a macro is to parse the text to column using
space as the delimiter then use a formula ro recombine them in the
format required then copy formulas & special paste values

example

cell a1 entry equals LastName Firstname

pased data becoms

b1 entry Lastnmae
c1 entry Firstname


formula in d1
=d1 & " " & c1

copy d1 & paste special value into e1

decopy e1 and paste into original sheet
 
Back
Top