How to add a comma in a cell

0

Hi,

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.

Answer
Discuss

Discussion

Is it after a certain number of spaces in each instance or just after anywhere there is a number? 
don (rep: 1950) 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