Separating number of lines from a cell

[Danbrix]

Hi

I hve a cell with as many as 100 lines and which can change depending on user input.

I can find how many lines there are using, but I want to separate the lines into different cells.

Is a way to separate number of lines just like we use mid, left and right with number of charaters?

Thanks

 

[Rick Rothstein]

I can find how many lines there are using, but I want to separate the lines into different cells.

Which cells do you want to separate them into... the ones to the right of the cell or the ones under the cell?

 

[Danbrix]

I want to separate them to the ones under.

Thanks

 

[Danbrix]

Ideally I want to separate a chunk of 25 lines.

 

[jtakw]

ADVERTISEMENT

?? @ Danbrix, why are you replying for the OP ??

 

[Danbrix]

Both the same person, not sure what hapoened but looks like it got mixed up.

 

[Fluff]

ADVERTISEMENT

@Danbrix
I have merged both accounts. In future please do not register multiple accounts as it is against board policy. See Rule#7

 

[Danbrix]

Thanks Fluff. Appreciate it.

 

[jtakw]

So, just to clarify, your Cell containing a variable number of "lines", does that mean they are separated by linefeeds ( carriage return, alt-enter )?

And you want it separated by chunks of 25 lines per cell, below the original cell ?

 

[Danbrix]

The cell is linked to a userform textbox where a user may enter a variable number of lines inside the textbox which ends up in the cell.

And ideally yes I want it separated by chunks of 25 lines.