| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on splitting into columns
In excel,i have a column having the phonenumber and emailid(both in
the same column) how to split into 2 ? please help me to split the phone number and email id into two different columns.... example : in column A ,is to be separated as 0998786751 in column B and in column C note:the length of phone number and email id may vary... Give me a formula not a macro.. there are 1000's of records like this |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting Numbers Into Different Columns | Excel Discussion (Misc queries) | |||
| Splitting Column in to 2 columns | Excel Discussion (Misc queries) | |||
| Splitting one column into multiple columns | Excel Worksheet Functions | |||
| Splitting text to columns | Excel Worksheet Functions | |||
| Splitting text in one column into two (or more) columns. | Excel Worksheet Functions | |||
Threaded Mode
