|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 7th, 2005, 04:05 PM
|
|||
|
|||
removing spaces
If I have imported records , that have the city, state and I want to put the
state in a seperate cell, but there are spaces to the right of the state, my access query will not do this unless I remove the spaces to the right. All the spaces to the right of the state are not the same. Is there a query that will remove the spaces and put the state in the next column? 
|
|
#2
March 7th, 2005, 05:25 PM
|
|||
|
|||
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Removing special characters and spaces | Ralph K. | General Discussion | 4 | September 7th, 2004 05:50 PM |
| Removing Spaces | Gary W | Running & Setting Up Queries | 1 | August 25th, 2004 08:15 PM |
| Removing extra spaces from a column of cells | Sandie | Worksheet Functions | 3 | August 12th, 2004 07:13 PM |
Linear Mode
