Home |
Search |
Today's Posts |
#1
|
|||
|
|||
breaking up a phone number
I need to break up a phone number into three different columns. I have column A that contains the phone number xxx-xxx-xxxx, I need to split that up into three different columns. Column B would equal the area code... column C would equal the Prefix.. and column D would equal the digits.. any suggestions on how to accomplish this? thanks -- maximus73 ------------------------------------------------------------------------ maximus73's Profile: http://www.excelforum.com/member.php...o&userid=25877 View this thread: http://www.excelforum.com/showthread...hreadid=392596 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Phone number | Excel Discussion (Misc queries) | |||
Phone Number Formats | Excel Discussion (Misc queries) | |||
Maximum number of rows? | Excel Discussion (Misc queries) | |||
duplicate number | Excel Discussion (Misc queries) | |||
Phone Dialer | Excel Discussion (Misc queries) |