Pesky spaces
 

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.

Pesky spaces
 

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

"Richard" wrote:

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.