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
|
|||
|
|||
How to remove blank spaces between numbers & letters in a column
Project numbers were previously typed in a colum with either one or two blank
spaces (i.e. P - 000-934-042). There should not be any blank spaces. I am trying to remove these blank spaces without having to retype so many numbers. The database contains about 3500 entries with about 400 typed in this incorrect format. I know there's a formula in Excel that can remove blank spaces within a column, but I don't know about Access. |
#2
|
|||
|
|||
How to remove blank spaces between numbers & letters in a column
You can use the Replace function to do this.
-- hth, SusanV "In a dilemna" In a wrote in message ... Project numbers were previously typed in a colum with either one or two blank spaces (i.e. P - 000-934-042). There should not be any blank spaces. I am trying to remove these blank spaces without having to retype so many numbers. The database contains about 3500 entries with about 400 typed in this incorrect format. I know there's a formula in Excel that can remove blank spaces within a column, but I don't know about Access. |
#3
|
|||
|
|||
How to remove blank spaces between numbers & letters in a column
Try and use the replace function to replace space with empty
Select Replace(FieldName," ","") As NewName From TableName -- I hope that helped Good Luck "In a dilemna" wrote: Project numbers were previously typed in a colum with either one or two blank spaces (i.e. P - 000-934-042). There should not be any blank spaces. I am trying to remove these blank spaces without having to retype so many numbers. The database contains about 3500 entries with about 400 typed in this incorrect format. I know there's a formula in Excel that can remove blank spaces within a column, but I don't know about Access. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
How to change column headings from numbers back to letters? | squeegests | General Discussions | 2 | September 1st, 2004 04:35 PM |
Want to remove spaces from behind numbers after pasting then in E. | Fritz571 | General Discussion | 1 | August 24th, 2004 12:40 AM |
Problem with sorting a column of numbers (descending) - top two cells are blank. | LDH | Worksheet Functions | 1 | August 13th, 2004 07:08 PM |
Column Labels switched from letters to numbers | Melanie | Setting up and Configuration | 1 | October 10th, 2003 12:44 AM |