Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Cell problem (2003)

    Picture this: One column in a spreadsheet displays telephone numbers, and every one of 3,000 records looks like this: 555 3214567 (there's a space between the area code and the rest of the number). We need to get rid of the space. How do we do that without requiring unskilled users to write programming code?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cell problem (2003)

    Select the column.
    Select Edit | Replace...
    Enter a space in the Find what box.
    Make sure that the Replace with box is empty.
    Click the Replace All button.
    If necessary, adjust the column width to display all digits.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Cell problem (2003)

    Oh, that's so easy...I'm embarrassed! <img src=/S/hiding.gif border=0 alt=hiding width=70 height=24>

    Thank you, Hans!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •