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.