I have a string of text with a coma and need to insert a space

R

Rick B

Is this a name field?

If so, I would highly recommend you stop and normalize your data. Your
first and last names should be stored in separate fields. Then you can
concatenate them and include a comma and a space.
 
G

Guest

Thanks for the replace idea, it worked great. I did not want to have to modiy
over 25,000 records. By the way it was data that I had to import into Access
in the exact format but just needed a space. Could not normalize the input
data.

Thanks again for your assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

case sensitive filter 5
Compare string contents ignoring order 24
simple structure, not so simple 1
Extracting the last word from a string. 2
VLookup and text strings 3
Need SUBSTRING like function 3
Extract only text from column 6
Text Fields changing case 2

Top