Need to remove spaces

**vonneffdobermans** · 02-26-2009, 09:38 PM

Hey all... I have a cel that has about 100,000 phone numbers and at the end of some and before sum, there are spaces added to end.

is there a formula, or a way to take everything away except for the 10 digit number?

Please help...

**shg** · 02-26-2009, 09:42 PM

In an adjacent cell, =trim(a1) and copy down.

**vonneffdobermans** · 02-26-2009, 10:04 PM

okay, that worked. However, I need just the number without the other beeing there. So when I copy it and paste it to notepad or something. then copy and paste again,, I get same spaces again.

AM I doing trhis wrong? I am sure I am.. lol

What do I need to do to remove spaces, but when original cell is deleted it will remain trimmed with no spaces.

**shg** · 02-26-2009, 11:07 PM

Copy the column with the formulas, then paste as values (Edit > Paste special, Values) over the original, then delete the formula column.

**vonneffdobermans** · 02-27-2009, 01:41 AM

awesome... Thanks alot...

**shg** · 02-27-2009, 01:46 AM

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes