Forum Discussion
How do I....
separate letters from numbers. For example I have Names and numbers in the same cell but i want to put all the names in one cell then the numbers in a different cell. There is no space between them or anything
Hi,
I think you can use "=MIN(IFERROR(FIND({"0","1","2","3","4","5","6","7","8","9"},A1,1),""))" to find where the first "Number" is located in your text that contains names and numbers in one cell.
