Phone Numbers Part 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings

Thanks to help from several of you, I discovered the very helpful ParsePhoneNumbers function on the Pearson site. What I want to know now is: How do I do the opposite? What if I've got two columns, one with area code and one with the local number and I want to combine them into one column. I also want to remove the "-" from the local number.

Thanks.
 
Hi
to comnine two strings (lets say cell A1 and B1) use
=A1 & B1

--
Regards
Frank Kabel
Frankfurt, Germany

Rob said:
Greetings,

Thanks to help from several of you, I discovered the very helpful
Click to expand...
ParsePhoneNumbers function on the Pearson site. What I want to know
now is: How do I do the opposite? What if I've got two columns, one
with area code and one with the local number and I want to combine them
into one column. I also want to remove the "-" from the local number.
 
Thanks for the help Frank! Also, what if I wanted to then delete columns A and B, leaving only C with the combined data? Right now if I delete A or B, it disrupts the formula in C.

Sorry for all the questions, I'm new to this kind of thing in Excel.
 
Hi
no problem asking questions here :-)
Try the following after you entered all the formulas
- select column C
- copy it (e.g. hit CTRL+C)
- goto 'Edit - Paste Special' and choose values
- now you can delete column A+B

--
Regards
Frank Kabel
Frankfurt, Germany

Rob said:
Thanks for the help Frank! Also, what if I wanted to then delete
Click to expand...
columns A and B, leaving only C with the combined data? Right now if I
delete A or B, it disrupts the formula in C.
 
Back
Top