VBA Addresses to be spilt into multiple columns such as add 1, add 2, City, County, PostCode

[vbanewbie68]

Hi Sir or Madam

Please see my screenshot below. With your help please I need to know how this column A be split into new (insert) multiple columns such as add 1, add 2, addr 3, City, County, Postcode and even country as well. Your help on this is much appreciated. Also I need to know how to remove commas if numbers are showing?

I look forward to hearing from you soon.

Best regards

Vbanewbie68

 

[Kerryx]

Yes you can use the option text to columns and select the option use the comma as your delimiter

You can then tidy the data up

 

[vbanewbie68]

Yes you can use the option text to columns and select the option use the comma as your delimiter
View attachment 63853
You can then tidy the data up

Thank you for this. I know this can do but would like to create vba codes for this please? Regards

 

[Joe4]

Thank you for this. I know this can do but would like to create vba codes for this please? Regards

Turn on your Macro Recorder, and record yourself performing the steps Kerryx proposed, and you will have VBA code that does that.

 

[vbanewbie68]

Turn on your Macro Recorder, and record yourself performing the steps Kerryx proposed, and you will have VBA code that does that.

Thank you for the information. I will follow your instructions, macro recorder. Best regards

 

[vbanewbie68]

Turn on your Macro Recorder, and record yourself performing the steps Kerryx proposed, and you will have VBA code that does that.

Thank you Joe4 and Kerryx looking into this issue and I am pleased that I am with the outcome of it. Again many thanks. Best regards
Vbanewbie

 

[Joe4]

You are welcome.
Glad we were able to help!

 

[Kerryx]

Glad to help