Hi
I have a list of addresses in an address column in an excel document, that has commas separating the full address.
What I would like to be able to do is to have a piece of vba code go through the column and remove the commas, adding a carriage return.
Does anyone have a piece of code as an example?
I have a list of addresses in an address column in an excel document, that has commas separating the full address.
What I would like to be able to do is to have a piece of vba code go through the column and remove the commas, adding a carriage return.
Does anyone have a piece of code as an example?