Need formula to split (555)555-5555LosAngeles

  • Thread starter Thread starter pc4n6
  • Start date Start date
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.
 
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
 
Thank you so much. I've used TextToColumns before. I had never used fixed
length. You saved me so much time.

pc4n6
 
Back
Top