Split data in cells

Good morning,

I have a spreadsheet that contains typical address information ... I would like to apply a filter so that the data is split into a table format... I started to use functions ...but i know there has to be an easier why to clean this sheet.....

I have attached an example ....

Items in yellow is the data I want to keep
Items in green is how the I would like the data to appear
Items is red are not required.


thank you in advance!

Hi

This should do the bulk of it for you.

Please Login or Register  to view this content.

rylo

I'm really sorry that I didn't respond earlier but this resolved my issue

Thank you so much!