Replace space with Underscore in cell within a table.

[dj2229]

Good day all

So I have a table created in access with email address's created. The way I am building these is by using the last 4 characters of the last name and the 1st character of the first name. So for example:

a person named Bob Johnson would be created as JohnB@etc.com

My problem is on people that have names with a space. So for example Bob Van Denberg is getting created ad Van B. The space is getting counted as the 4th character.

How do I replace the space with an underscore or better yet, ignore any spaces in the creation?

Thanks in advance!

[tigeravatar]

dj2229,

Welcome to the forum!
This is in the Access forum, so I'm assuming you're doing this in Access. You can perform this action using an Update query:

Please Login or Register  to view this content.