| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to split (555)555-5555LosAngeles
Hi,
Is there a macro or how can I use a function to split (555)555-5555LosAngeles into two separate cells? Would really appreciate the help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need formula to split (555)555-5555LosAngeles
Hi
Look at the 'TextToColumns function on the Data menu. As I assume the phone number is a fixed length, use the fixed width option and follow the wizard. Regards, Per "pc4n6" skrev i meddelelsen ... Hi, Is there a macro or how can I use a function to split (555)555-5555LosAngeles into two separate cells? Would really appreciate the help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need formula to split (555)555-5555LosAngeles
Thank you so much. I've used TextToColumns before. I had never used fixed
length. You saved me so much time. pc4n6 "Per Jessen" wrote: Hi Look at the 'TextToColumns function on the Data menu. As I assume the phone number is a fixed length, use the fixed width option and follow the wizard. Regards, Per "pc4n6" skrev i meddelelsen ... Hi, Is there a macro or how can I use a function to split (555)555-5555LosAngeles into two separate cells? Would really appreciate the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split cells with each having a formula possible? | Excel Worksheet Functions | |||
| split cells with each having a formula possible? | Excel Worksheet Functions | |||
| Formula to Split First and Last Names | Excel Worksheet Functions | |||
| Formula Split or parenthesis problem? | Excel Discussion (Misc queries) | |||
| How do I split data in a column (formula)? | Excel Discussion (Misc queries) | |||
Linear Mode
