Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

I have a list of telephone numbers and I wish to format them with a space , I wish to add a space after the 5th character if the first 5 characters match a set number of numbers.

e.g the numbers

441289307028

441482869861

442083032228

If any of the above numbers start with "4420","4423","4424","4428" then format them with a space after the 5th character.

So the results would be

441289307028

441482869861

44208 3032228

Any help would be great!

e.g the numbers

441289307028

441482869861

442083032228

If any of the above numbers start with "4420","4423","4424","4428

So the results would be

441289307028

441482869861

44208 3032228

Any help would be great!

=IF(OR(LEFT(A1,4)="4420",L

Please check the attached example.

jppinto

Book1.xlsx

Please check the attached file.

jppinto

Book1.xlsx

All the numbers I have are telephone numbers and I wish to put them in the correct UK format , 3 out of the 4 formulas for the different types of telcode are below

=IF(OR(LEFT(A1,4)="4420",L

=IF(OR(LEFT(A1,7)="4413873

=IF(OR(LEFT(A1,6)="44113",

The fourth type just needs a space added after the 5th character which is a majority of all the numbers.

How do I put these formulas all together so that it produces the correct results for all types of numbers? Or am I floggin a dead horse! ;)

Thank You

=IF(OR(LEFT(A1,4)="4420",L

If you want to add an aditional formula, it would look even worst!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.