On 2002-05-08 18:45, mtann wrote:
ANY HELP OR IDEAS?
I have a sheet with 70 char's in Colum A
I need to put the first 30 char's in A, next 10 in B, and all remaining in C
Thanks
Matt
On 2002-05-08 20:03, Yogi Anand wrote:
On 2002-05-08 18:45, mtann wrote:
ANY HELP OR IDEAS?
I have a sheet with 70 char's in Colum A
I need to put the first 30 char's in A, next 10 in B, and all remaining in C
Thanks
Matt
You can do it with DATA|Text_to_columns.
Hoever if you must do it with a formula --
if your entry is in cell A1, then
in A2 ... =left(a1,30)
in B2 ... =mid(a1,31,40)
in C2 ... =right(a1,30)
Regards!
On 2002-05-11 03:27, Chris Davison wrote:
Yogi,
you mean in most cases where there are only 2 columns and the rest are in column 2 ?
yours will never work in most cases of 3 columns !
I see what you're thinking, just didn't want to confuse the person asking the question which relates to 3 columns spcifically
Chris