I need to format columns to allow only 7 characters and the rest of the data
to go into column B
--
JTEFUN

"JTEFUN" wrote in message
...
I need to format columns to allow only 7 characters and the rest of the
data
to go into column B
--
JTEFUN



If you mean that if a user types a lot of data into the one cell and that
when they reach 7 characters the rest of the data is automatically inserted
into the next cell, then I don't think you can do that. (Might by code -
someone will tell you...)

"JTEFUN" wrote in message
...
I need to format columns to allow only 7 characters and the rest of the
data
to go into column B
--
JTEFUN



If you mean that if a user types a lot of data into the one cell and that
when they reach 7 characters the rest of the data is automatically inserted
into the next cell, then I don't think you can do that. (Might by code -
someone will tell you...)

Please, do not multipost


--
Regards,

Peo Sjoblom



"JTEFUN" wrote in message
...
I need to format columns to allow only 7 characters and the rest of the
data
to go into column B
--
JTEFUN

"JTEFUN" wrote in message
...
I need to format columns to allow only 7 characters and the rest of the
data
to go into column B
--
JTEFUN

Column A: Input
Column B: =LEFT(A1,7) will abstract the first 7 characters
Column C: =MID(A1,8,99) will abstract characters 8 through 99

Regards.

Bill Ridgeway
Computer Solutions