Split out text after each incidence of a comma

[djfatboyfats]

Good afternoon,

I want to place different parts of an address into separate columns that appear after each comma

Address Line 1
Address Line 2
Address Line 3
Address Line 4 (If Applicable)

Example Text

123 The Street, Sevenoaks, Kent

I know this can be done by performing a text to columns but I want to do this outside of this.

Currently I am using this for the 1st part of the address

Please Login or Register  to view this content.

And this for the last part

Please Login or Register  to view this content.

But I need something for the middle parts

I don't mind having a separate code in each column to pull the data out

Regards

DJ

[AlKey]

Try this formula

In B1 and pull it to the right until you see blanks

=TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",255)),(COLUMNS($A:A)-1)*255+1,255))

	A	B	C	D
1	123 The Street, Sevenoaks, Kent	123 The Street	Sevenoaks	Kent

[djfatboyfats]

Brilliant thank you

[AlKey]

You're welcome and thank you for the feedback!