Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to remove blank spaces between numbers & letters in a column

Discussion in 'Information Technology' started by In a dilemna, Nov 15, 2005.

  1. In a dilemna

    In a dilemna
    Expand Collapse
    Guest

    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. Loading...


  3. SusanV

    SusanV
    Expand Collapse
    Guest

    You can use the Replace function to do this.

    --
    hth,
    SusanV

    "In a dilemna" <In a dilemna@discussions.microsoft.com> wrote in message
    news:45649480-04E4-42DC-ABB0-CD12904C65E0@microsoft.com...
    > 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.
     
  4. Ofer

    Ofer
    Expand Collapse
    Guest

    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.
     

Share This Page