T
Todd
I have a cell range that have Last Name, First Name
format. The problem is that some cells have a space
between the comma and the first name and some have no
space. This is causing a problem when I try to use the
=substitute(A1,",",", ") formula because it adds an extra
space in the ones that already have a space. Any ideas on
how I can keep the ones that already have a space from
getting an extra space? Thanks for the help.
format. The problem is that some cells have a space
between the comma and the first name and some have no
space. This is causing a problem when I try to use the
=substitute(A1,",",", ") formula because it adds an extra
space in the ones that already have a space. Any ideas on
how I can keep the ones that already have a space from
getting an extra space? Thanks for the help.