FORMATING COLUMNS..... HELP

[Guest]

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

 

[Gordon]

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

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

 

[Gordon]

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

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

 

[Peo Sjoblom]

Please, do not multipost

 

[Bill Ridgeway]

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

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