I would like to know if it is possible to extract information from one cell into
another cell in the same row.

I have for example in A1: Jones (Smith) I would like to remove (Smith) from A1:
and insert it into B1: as Smith. there may or may not be a () selection in
column A.

Any help or suggestions as always, are greatly appreciated.

--

Regards
Michael Koerner