Splitting string into two columns!

[fahadferoz]

In the attached file in A2 cell you will see a name: MILMIL414. Here MILMIL is the area name and 414 is area code. I need to split it to two like the spreadsheet. IN C2 it needs to show the area name and in D2 it needs to show the area code.

Please help me to sort the problem.

Thanks for your kind attention!

 

[Hui]

C2: =LEFT(A2,6)
D2: =VALUE(RIGHT(A2,3))
Copy both down

these assume a 6 character 3 number system

 

[fahadferoz]

Mr Hui

You make everything look so simple..Love your work!!

Thanks a lot!

 

[Hui]

If you delete Column B
Then just start typing the values
MILMIL
PITHOM
OKCTUL

After the 2nd or 3rd Cell Excel will automagically extend the logic to the end of the data
Same with the numbers

This only applies to Excel 2013+