Hard carriage return at the end of cell

[Charles Coyner]

I'm looking for a formula to give a hard carriage return at the end of a 70 character cell. Word wrap will not work as it disturbs the form I'm trying to create.
I would like this to be accomplished automatically after 70 characters have been typed. I have tried several formulas to count characters but nothing I've tried seems to work.
Please help

 

[GS]

I'm looking for a formula to give a hard carriage return at the end of a 70
character cell. Word wrap will not work as it disturbs the form I'm trying
to create. I would like this to be accomplished automatically after 70
characters have been typed. I have tried several formulas to count
characters but nothing I've tried seems to work. Please help

This can be done using a formula, but not in the cell containing the
text unless the text is stored elsewhere and helper cells are used to
parse the contents. Expect weird results when not using a mono-space
font!

Try using Alt+Enter. Otherwise, you'll need VBA in an event procedure
if you want to update an existing cell after changes are made.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Salmon Egg]

I'm looking for a formula to give a hard carriage return at the end of a 70
character cell. Word wrap will not work as it disturbs the form I'm trying
to create.
I would like this to be accomplished automatically after 70 characters have
been typed. I have tried several formulas to count characters but nothing
I've tried seems to work.
Please help

What are you trying to do? Do you just wish to send an ASCII CR? What do
you expect to happen to a spreadsheet containing such a cell? What are
you expecting a printer printing such a cell to do?

Just for the hell of it, I will see what happens if I concatenate a
string in a cell with a carriage return.

--

Sam

Conservatives are against Darwinism but for natural selection.
Liberals are for Darwinism but totally against any selection.