Formula Help

[AlligatorMtn]

OK so here is what I have...

I've got a list of names and phone numbers.

Column A has Names on the left and the numbers on the right
I have a formula to get the numbers out of the column and into column
b, but when it comes time to delete the numbers out of column A, it
won't work without deleted the numbers that were copied onto column b.

So we've tried a formula that will copy the names from column A and
place them into another column, then you would need to copy and paste
that information back into column A, but it will not let you.

Does anyone have a formula that will delete part of this text without
removing the inofrmation that i've placed in column B.


my email is (e-mail address removed) - any help is needed/appreciated!!!

 

[JE McGimpsey]

Does anyone have a formula that will delete part of this text without
removing the inofrmation that i've placed in column B.

First thing I'd ask is whether you can use Data/Text to Columns... to
separate the names from the phone numbers (e.g., if the phone numbers
start with a left parenthesis, use that as a delimiting character).

If not, then you could

1) Put the formula that extracts the name in an empty column, say column
D.

2) Put the formula that extracts the phone number in the next column
(column E).

3) Select both columns D & E and copy them.

4) Select columns A & B and choose Edit/Paste Special, selecting the
Values radio button.