Changing text appearance
=LOWER(SUBSTITUTE(A1," "
"Max Prophet" wrote:
If cell A1 contains the text "Jane Doe", and I would like the the adjoining
cell to display as ", how would I go about doing
that? I basically have a column of data (first name and last names) I would
like to format in that manner.
Thanks in advance for any advice.
|