Hi,

Does anyone know the formula to separate text from numbers?
I tried applying the formula from an earlier post here (=LEFT(A1,LEN(A1)-B1)
=RIGHT(A1,LEN(A1)-B1+1) but it didn't work for me.
Did I miss something? Any help you can provide is greatly appreciated