"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...)