Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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: 1989) 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