I need to extract text in a single cell that is seperated by commas and place the text in there own seperate cell. Example below:
129 High street, billericay, essex, cm12 9ah
does anyone have a formular as i have hundreds of addresses like this.
Many thanks
129 High street, billericay, essex, cm12 9ah
does anyone have a formular as i have hundreds of addresses like this.
Many thanks