If A1 is [Jones,Mike], how can I get it to seperate but still use the first name as text in the other cell? Yes, text to columns would work greatly, but it does let me use the first name in a formula.
A:
With name in A1, for surname:
=LEFT(A1,FIND(",",A1,1)-1)
For first name(s):
=RIGHT(A1,FIND(", ",A1,1)-2)
James
2010-05-31 20:48:36
thanks james but when i input the formula it didnt work.
terry
2010-05-31 21:20:16
what does it give you?
James
2010-05-31 22:39:55