Pesky spaces

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I have a column of names that are current formatted as "lastname space space
firstname". However, what I would like to see is the column formatted as
"lastname comma space firstname". Essentially, I would like to change the
first space into a comma. Any ideas on how? The names are all different
lengths. Please note I do not know any VBA.
 
One quick way could be

Edit|Replace

replace what -Space Space
replace with ,space

As long as you don't have other double spaces this would work.

Mike
 
Back
Top