I am in need of a solution to split a paste string into multiple cells within
a row.
There are 7 to 8 entries in this string, an example would be
M1234 2008000 Doe, Jane Mary 33Y(05/05/2000) F ER (8 string entry)
or
M5678 1234567 Lee, Jack 70Y(01/01/1900) M Psych (7 string entry)

Using the first example to expand on the needs of this project:
M1234 2008000 -- should go to Cell A1
Doe, Jane Mary -- should go to Cell A2
33Y(05/05/2000) F - should go to Cell A3
ER -- to go to Cell A4
*what complicates matters is there is not always a middle name so the string
length varies from 7 and 8 entries (seperated by commas). But there will
always be an age (number) to start the next cell after the name.

Idealy if a user pasted this string of information into cell A1, it would
take it and split it up between A1 and A4.

Any help would be GREATLY appreciated,
Thank you,
Luke Slotwinski