B
bianling
I'm sure that has been solved before, but I cannot find or figure ou
the right formula so far.
I have a column of cells that have the first name, middle name(s) an
last name in that order in one cell.
I've seen formulas to extract the first or last word of a cell.
I want to extract the first name and middle names, that is all word
except the last word (or last name).
Thank you for replying with the solution
the right formula so far.
I have a column of cells that have the first name, middle name(s) an
last name in that order in one cell.
I've seen formulas to extract the first or last word of a cell.
I want to extract the first name and middle names, that is all word
except the last word (or last name).
Thank you for replying with the solution