Separate_no_and_text_by_excel_formula

[Narend]

Respected member,

I want a solution for the attached document which contains a word like :=
1234Amit 1234 Amit
Amit1234 Amit 1234
Now what I want in a different cell 1234 and Amit in a different cell and same
Amit and 1234 both are in a different cell.

All this I want to be done by Excel formula only.


Regards

Narendra

 

[Marc L]

As length is 8 and you want 4 chars is separate cells,
just use LEFT or RIGHT Excel functions …​

 

[deciog]

Narend

my contribution

B1 =MID(A1,1,4)
C1 =MID(A1,5,4)

Décio

 

[Deepak]

As mark said if length is fixed then you may also use the text to column with fixed width.

 

[rahulshewale1]

Dear narend,

please find the attached formula base solution and text to columns .

 

[Narend]

Narend

my contribution

B1 =MID(A1,1,4)
C1 =MID(A1,5,4)

Décio