Thread
:
Adding a space in text
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
MB
Posts: n/a
Adding a space in text
WOW! You are all so wonderful! Thank you!!
--
MB
"Don Guillett" wrote:
you said a formula, so
=LEFT(D4,FIND(",",D4)) & " "&MID(D4,FIND(",",D4)+1,LEN(D4)-FIND(",",D4)+2)
--
Don Guillett
SalesAid Software
"MB" wrote in message
...
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
Reply With Quote