Need formula to split (555)555-5555LosAngeles

P

pc4n6

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.
 
P

Per Jessen

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
 
P

pc4n6

Thank you so much. I've used TextToColumns before. I had never used fixed
length. You saved me so much time.

pc4n6
 
Top