Text Limt in a cell

[Sunil99580]

Hey,
I have a query regarding the text limit on a cell. I have a cell that contains more than 100 characters. I have given the reference of that cell to other sheets now what I want is that on the sheet the cell will only have 100 characters the rest will move to the next cell.

Exp. A cell has 140 characters 100 will be on the C1 and the rest will be on D1.

 

[Peter_SSs]

Do you just mean this?
In C1: =LEFT(B1,100)
In D2: =REPLACE(B1,1,100,"")

 

[Sunil99580]

Thanks for the help buddy

 

[Peter_SSs]

You're welcome.