Removing Comma from name

Try this

Formula:

Please Login or Register  to view this content.

v	A	B
1	Smith, James	Smith James

You can do this without using formulas.

Select the cell(s) in question
Goto the Home tab>Find & Select>Replace

Find what: , (enter a comma)
Replace with: nothing, leave this blank
Replace All