"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