Insert alt enter into a cell or a column with defined comma counted

[Kevincwk2000]

Dear Sir,

I am looking for a code to insert alt-enter into a cell or a column with a defined comma count per line, saying 5

is

C1,C2,C3,C4,C5,C6,C7
C8,C9,C10,C11

want to change the cell(s) as

C1,C2,C3,C4,C5,
C6,C7,C8,C9,C10,
C11

thanks,
Kevin

 

[Kevincwk2000]

Hi Mick,

I found a bug in the code.

WAS:-
C8,C84,C202,C206,C212,C215,C239,C241
C243,C244,C245,C291,C294,C341,C343,C344
C345,C367,C389,C391,C392,C393,C395,C439
C441

run the code will become:-
C8,C84,C202,C206,C212,
C215,C239,C241C243,C244,C245,
C291,C294,C341,C343,C344C345,
C367,C389,C391,C392,C393,
C395,C439C441

Highlighted in RED are the problems

thanks,
Kevin

 

[MickG]

Hi, The reason is that, where you find this error, you do not have a comma to deliminate the individual values ,unless you have a different criteria for the delimination, or enter a comma at the end of each value, you will always get this result.
If all you values start with a "C", perhaps you could use that !
Mick