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

eliminating blank spaces

P: n/a
In my table I imported from .txt, one of my columns has blank spaces.

The column is as follows, how do I eliminate the blank spaces in between the
second and third, and fifth and sixth digits?

12 345 6789
78 241 5869
04 258 3695
14 254 1136
00 045 0285

My whole column is formatted this way.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200705/1

May 11 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On May 11, 1:03 pm, "ShaeMills via AccessMonster.com" <u33729@uwe>
wrote:
In my table I imported from .txt, one of my columns has blank spaces.

The column is as follows, how do I eliminate the blank spaces in between the
second and third, and fifth and sixth digits?

12 345 6789
78 241 5869
04 258 3695
14 254 1136
00 045 0285

My whole column is formatted this way.

--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...
**TRY THIS ON A COPY OF YOUR TABLE FIRST!!**
Highlight the column that contains your data with spaces. In the Edit
menu, choose Replace. For the "Find What", enter a space. Leave the
"Replace With" field blank. Make sure the "Match Whole Field" is NOT
checked, and the "Search Only Current Field" IS checked. Click the
"Replace All" button, and voila!

HTH,
Jana

May 11 '07 #2

P: n/a
Jana, Thanx it worked... r, Shae

Jana wrote:
>On May 11, 1:03 pm, "ShaeMills via AccessMonster.com" <u33729@uwe>
wrote:
>In my table I imported from .txt, one of my columns has blank spaces.
[quoted text clipped - 11 lines]
>--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...

**TRY THIS ON A COPY OF YOUR TABLE FIRST!!**
Highlight the column that contains your data with spaces. In the Edit
menu, choose Replace. For the "Find What", enter a space. Leave the
"Replace With" field blank. Make sure the "Match Whole Field" is NOT
checked, and the "Search Only Current Field" IS checked. Click the
"Replace All" button, and voila!

HTH,
Jana
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200705/1

May 11 '07 #3

P: n/a
On May 11, 1:51 pm, "ShaeMills via AccessMonster.com" <u33729@uwe>
wrote:
Jana, Thanx it worked... r, Shae

Jana wrote:
On May 11, 1:03 pm, "ShaeMills via AccessMonster.com" <u33729@uwe>
wrote:
In my table I imported from .txt, one of my columns has blank spaces.
[quoted text clipped - 11 lines]
--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...
**TRY THIS ON A COPY OF YOUR TABLE FIRST!!**
Highlight the column that contains your data with spaces. In the Edit
menu, choose Replace. For the "Find What", enter a space. Leave the
"Replace With" field blank. Make sure the "Match Whole Field" is NOT
checked, and the "Search Only Current Field" IS checked. Click the
"Replace All" button, and voila!
HTH,
Jana

--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...- Hide quoted text -

- Show quoted text -
Shae:
Glad I could help!

Jana

May 11 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.