Hi,

I have the following address text in a single column, which I need to strip out into 3 columns for database import. The text string example is:

12th floor TD Centre 201 Portage Avenue PO Box 6600 Winnipeg, MB R3C 3A7 Canada

I can strip out the "Canada" and the State/postcode: "R3C 3A7" by using several =right commands, but I need to separate out the City "Winnipeg" separately and then everything else to the left of the "," as a separate single column. This comma is the only indicator to break out the address data. Therefore it should look like this: (in for separate columns)

12th floor TD Centre 201 Portage Avenue PO Box 6600 | Winnipeg | MB | R3C3A7 | Canada

Hoping someone can help. Thanks.