I have a worksheet with a column listing addresses. Unfortunately, the
whole address in each case is entered in a single cell with just commas
separating the different lines, ie:

John Smith, 5 High Street, Anytown, Any County, AB12 CD5

How can I extract the data in these cells and place them in separate
columns, so that the address in cell A1 separates to:

A2 becomes John Smith
A3 becomes 5 High Street
etc, etc

Many thanks.