name separation
Assuming 'Doe, John' is in Cell A1...
=LEFT(A1,FIND(", ",A1)-1) equals 'Doe'
=RIGHT(A1,LEN(A1)-FIND(", ",A1)-1) equals 'John'
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown
"Help with Cell question" wrote:
how do i separate a single cell name "Doe, John" into two separate cells?
|