Separating Text from the numbers in same cell

[mzalikhan]

Hi Everybody

Here is my question. I have got a situation in which i have a combination of text and number in the same cell. I want to separate text and number into two different cells.
For example, I have
A1 BKN300

I want

B1 BKN
C1 300

Peace
Muhammad Zeeshan

 

[shift-del]

Hello Muhammad

If it's always 3 letters and 3 digits:

=LEFT(A1,3)
=RIGHT(A1,3)

 

[mzalikhan]

Thanks shift-del.
Peace

 

[shift-del]

RIGHT() returns a text. If you need a number then you have to amend the formula.

=--RIGHT(A1,3)