Adding a space in text
This seems to work:
=LEFT(A1,FIND(",",A1)) & " " & RIGHT(A1, LEN(A1)-FIND(",",A1))
--
Kevin Vaughn
"MB" wrote:
Hello experts,
A previous employee created a spreadsheet whereas in Column A are employee
names as follows:
Doe,John
Is there a formula that would add a space between the column and first name?
Thanks so much for your help! I'm using Excel 2003.
--
MB
|