dbwiz
Active Member
- Joined
- Nov 20, 2007
- Messages
- 275
Scenario: A column of names that have last name space first name space and then a middle name or initial have to be converted to comma delimited text for uploading into a program. So for example if the Excel column has the names
Smith Joseph Edgar
Doe Sally J
when converted it needs to look like
Smith, Joseph Edgar
Doe, Sally J
I tried Edit Replace and Find all, I hit the tab key once and replaced with , but got
Smith, Joseph, Edgar,,,,,,
So that didn't work. Is there an easy way to do this?
Smith Joseph Edgar
Doe Sally J
when converted it needs to look like
Smith, Joseph Edgar
Doe, Sally J
I tried Edit Replace and Find all, I hit the tab key once and replaced with , but got
Smith, Joseph, Edgar,,,,,,
So that didn't work. Is there an easy way to do this?