Adding a comma between single digits in a cell

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,802
Nice, Rick, I hadn't seen that version before. Much cleaner.
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,957
Office Version
2010
Platform
Windows
Nice, Rick
Thanks!



I hadn't seen that version before.
Me either... I made it up on the spot. In thinking about it now, I vaguely remember doing something in a similar vein in VBA using String and Format a while ago, so maybe that was in the back of my mind when I dummied up the formula for the initial testing.
 
Last edited:

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,921
Office Version
2007
Platform
Windows
Thanks!

Me either... I made it up on the spot. In thinking about it now, I vaguely remember doing something in a similar vein in VBA using String and Format a while ago, so maybe that was in the back of my mind when I dummied up the formula for the initial testing.

Congratulations Rick for the ability you have to solve it on the spot. And for sharing it with mortals.
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,957
Office Version
2010
Platform
Windows
Congratulations Rick for the ability you have to solve it on the spot. And for sharing it with mortals.
Uh, I am one of the mortals also you know. I just got lucky and thought up a simple formula using a somewhat different approach, that is all.
 

Watch MrExcel Video

Forum statistics

Threads
1,100,020
Messages
5,472,036
Members
406,796
Latest member
rebson

This Week's Hot Topics

Top