G
Guest
I need to format columns to allow only 7 characters and the rest of the data
to go into column B
to go into column B
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gordon
JTEFUN said: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...)
G
Gordon
JTEFUN said: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...)
P
Peo Sjoblom
Please, do not multipost
B
Bill Ridgeway
JTEFUN said: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