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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Language of the templates 0
Use of Wildcard characters with replace 2
convert columns to rows 6
Conditional add border in a range 3
Formatting phone numbers 5
Sorting Data 3
vlookup and multiple rowns that meet criteria 3
2007 Formula Needed to Update Table Values 8

Top