Function to put space and comma in-between numbers

[JM6544088]

Hi Experts
I am unable to get space & comma in between two numbers when "if" function is used
I am using following "if function"; end results numbers are all together,
Any suggestions? & lengthy function to make tidy? ( not VBA trained)

IF(B20=A20+1,A20&B20,"")&IF(C20=B20+1,B20&C20,"")&IF(D20=C20+1,C20&D20,"")&IF(E20=D20+1,D20&E20,"")&IF(F20=E20+1,E20&F20,"")&IF(G20=F20+1,F20&G20,"")

please see attached file

Thanks
jm

[Fluff13]

How about

Please Login or Register  to view this content.

It will probably need to be confirmed with Ctrl Shift Enter, rather then just Enter

[JM6544088]

Hi, Fluff13,
Brilliant function. My function was lengthy and tedious
Suggested by you is awesome! solved my issue
Thanks
JM

[Fluff13]

Glad to help & thanks for the feedback.