By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,816 Members | 2,151 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,816 IT Pros & Developers. It's quick & easy.

Removing Spaces in Text Data

P: 5
Hello,

In MS Access I have a field that contains data which looks like this example, GZQ 678239; GZQ 014312; etc. How do I remove the spaces to make it become (not just look like) GZQ678239; GZQ014312; etc. I noticed the trim function but don't think it applies here?

Thanks for your help,

John
Mar 9 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,359
Expand|Select|Wrap|Line Numbers
  1. Replace([Field Name], " ", "")
Mar 9 '07 #2

P: 5
Thanks for the help, appreciate it. I had actually looked at it again and solved my own problem. I used find and replaced, found any space, and replaced it with nothing, and it worked like a bomb, but thanks anyway.

John
Mar 12 '07 #3

Rabbit
Expert Mod 10K+
P: 12,359
Not a problem, glad you found a solution.
Mar 12 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.