Solved: word wrap or new line

[vzachin]

hi,

i have text in A1, where i want it to either wrap or
new line(carriage return?) after every 58 characters.
is this possible?

if it is possible, then i would like the following:
in cell b2, show the first 58 characters
in cell b3, show the next 58 characters
and so forth...


thanks
zach

[matthewspatrick]

zach,

In B2:
=MID($A$1,58*(ROW(B1)-1)+1,58)

Copy down as needed.

[vzachin]

hi Patrick,

thanks for the solution for my 2nd question.


zach