Substitue Function

[Memar]

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I just want to substitute a character between first name and last name and I also need to add a space between first name and last name.
Can I use the substitute function to perform both actions as once?
GEORGE/JAMES A - Exported data
George, James A – Desired result
I used substitute function and was able to substitute the “/ “to “,” =SUBSTITUTE(G30,"/",",",1) . Would you please modifying this formula to add the space between first name and last name?
Thanks for your time and help.

 

[Richard Schollar]

Hi

You'll kick yourself cos you practically had it:

=SUBSTITUTE(G30,"/",", ",1)

 

[Jonmo1]

Try

=SUBSTITUTE(G30,"/",", ",1)

This substitutes "/" with ", " <--notice the space after the comma