Copying a statement from the web creates a string of info with no delineation
Are you copying by selecting then Copy (command v)?
If this is a bank statement, can you instead download a comma separated values (csv) file? My bank allows various formats for downloading statements, and csv will open in Numbers. The commas delineate columns.
To parse a string that has a space or some other consistent character like a comma separating the text in cell D9 (Smith, Mary):
=LEFT(D9,FIND(“,",D9)−1) will return "Smith" and =RIGHT(D9,LEN(D9)−FIND(“,”,D9,1)-1) will return "Mary"
This is all characters to the left of the position of the comma, minus one so that the comma itself is not included, for the last name;
and all characters to the right of the comma (the length of the text, minus the position of the comma, minus 1 so the space is not included) for the first name.
FIND(",",D9) is the same as FIND (",",D9,1) since the starting position of 1 is assumed if not stated.
If you want the position of a space instead, use FIND(" ",D9)
Sometimes when I am doing a complex parsing, I put the lengths and positions in separate columns to make the logic easier to see.