| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text to columns question
Hi, I need help with this problem. I have two columns one that lists phon numbers and the other one that lists the count. I could easily do a text to columns however, some of the numbers i sequence are shown with a -. i.e.2095381654-1655. Do you know of a macro or the code that I could use to solve thi problem. Thanks in advance, Column 1: Numbers 2095381654-1655, 2095382304, 2095382555, 2095384761, 2095386204 2095386386 Column 2: Count Numbers 7 Jo -- spanish ----------------------------------------------------------------------- spanishj's Profile: http://www.excelforum.com/member.php...fo&userid=3580 View this thread: http://www.excelforum.com/showthread.php?threadid=55579 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another Text to Columns question | Excel Discussion (Misc queries) | |||
| Text to Columns Question | Excel Discussion (Misc queries) | |||
| Text to Columns Question | Excel Discussion (Misc queries) | |||
| Text to columns question | Excel Worksheet Functions | |||
| Text to Columns Question | Excel Worksheet Functions | |||
Threaded Mode
