How to add a comma in a cell



If I have a cell with a physical address ex:(STAND 2427 TLHABANE WES EXT 1 STAND 2427 TLHABANE WES EXT 1), how can I add a comma at the end of each number?

What I want to achieve through this is to use the commas to delimmit the cell into 3 separate cells/colomns.

At the moment I only have 1 collumn with over  8000 addresses. And each adress looks differend.



Is it after a certain number of spaces in each instance or just after anywhere there is a number? 
don (rep: 1969) Jul 7, '20 at 8:33 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login