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.

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.

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.