=RIGHT(A1,LEN(A1)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))+1)




=LEFT(A1,MIN(FIND({0,1,3,4,5,6,8,9},A1&"0123456789"))+9)





=CONCATENATE 

=CONCATENATE(B1,A1)






how to separate numbers from text in excel



=LEFT(A3,MIN(FIND({0,1,3,4,5,6,8,9},A3&"0123456789"))+9)


=CONCATENATE(B1,A1)


=RIGHT(A1, LEN(A1)-17)




=RIGHT(A1, LEN(A1)-17)