If you post an example of the data you are working with, someone may
be able to help you.


HTH,
JP

On Jan 16, 8:45*am, Santi wrote:
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