Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

If you really want to get it in a single cell:

Be "Davidson, Lauren O." (without the QMs) in A11 and the formula

=MID(A11;FIND(",";A11)+2;1024)&" "&LEFT(A11;FIND(",";A11)-1)

in another cell (best B11) you'll get what you want if the syntax you described by giving an example is "complete" enough. Names that do not contain exactly one occurrence of a comma followed by a single space or names containing trailing spaces will cause complications.

I would prefer using (a) helper(s) column(s).

If you really want to get it in a single cell:

Be "Davidson, Lauren O." (without the QMs) in A11 (and the other names from there downward in column A) and the formula

=MID(A11;FIND(",";A11)+2;1024)&" "&LEFT(A11;FIND(",";A11)-1)

in another cell (best B11) and filled downward in its column as needed, you'll get what you want if the syntax you described by giving an example is "complete" enough. Names that do not contain exactly one occurrence of a comma followed by a single space or names containing trailing spaces will cause complications.

I would prefer using (a) helper(s) column(s).