Copying Splitting Words In Excel?

I have lots of data in ms excel and have put commas separating the words for the text to column link to work on the data tab, but is there a wayi can make excel putin the commas in the correct place for me for example:


Mrs Kate Fleming


Mrs,Kate,Flemming


making the computer to know to put the commas in after Mrs Kate and Fleming. Please help.Copying Splitting Words In Excel?
you can use a find and replace.


-hit Ctrl-H





or


- click Edit


- click Replace


- in the find what box...just put a space


- in the replace box, put a comma


- then click replace all





keep in mind, every space will be changed to a comma. it works for this sample.Copying Splitting Words In Excel?
Forgive me if I'm wrong and you're on an older version of Excel...





But from at least 03 on, you don't need commas to use the Text-to-columns feature...





When the wizard comes up, you have two options: Delimited and Fixed Width





Fixed Width means that there is a space between each field you want parsed into a column.





Other than that, there is no easy way to insert commas where spaces are. You could do it using some VBA scripting, but it would be a headache and might produce some unwanted results...