RE: breaking up a phone number
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Use Data > Text to Columns...
This will split the fields very nicely.
--
Gary's Student
"maximus73" wrote:
>
> 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?action=getinfo&userid=25877
> View this thread:
http://www.excelforum.com/showthread.php?threadid=392596
>
>
.
Relevant Pages
- RE: breaking up a phone number
... "maximus73" wrote: ... column C would equal the Prefix.. ... > any suggestions on how to accomplish this? ... Prev by Date: ...
(microsoft.public.excel.misc) - Re: how to do a call back between forms
... knowing what you want to accomplish and being able to do that are two different things. ... It also falls on the student to show some humility when it becomes apparent that they need more information than that which they asked for, and to acknowledge that there is room for improvement in learning how to do things. ... I *did* take the time to point out *why* the solution you posted does not match the stated goal, but you've shown no inclination to acknowledge that discrepancy, nor have you shown any inclination to resolve it by explaining either a) that you stated your goal incorrectly and that a reference to the main class is indeed fine with you, or that b) your posted solution turns out to not achieve the goal of avoiding a reference to the main class after all. ... But your posted solution does not follow his suggestion, nor would either solution posted meet your stated goal of not wanting a reference to the main class in the secondary class. ...
(microsoft.public.dotnet.languages.csharp) - Re: Beatle Hater William F. Buckley Dead At 82
... the Reagan presidency didn't accomplish very ... a smart teacher politely corrects and tries to ... educate the student. ...
(rec.music.beatles) - Re: Is this sentence correct and appropriate for resume?
... The program usually takes a student 5.5 years to ... accomplish. ... If you chop a cord of wood into fireplace-size pieces in half ...
(alt.usage.english) - Re: what makes it true?
... student of mathematics at the University of Helsinki ... Prev by Date: ...
(sci.math) |
|
