Alternative Text to cells??
Posted by Gary Hewitt-Long on November 21, 2001 5:36 PM
Does anyone know of an easy way to do the following?
I have a list of product descriptions of varying lengths in Column A.
I need to cut the descriptions down to fit into three different columns depending on a preset limit of characters in each column.
Column B can only have a maximum of 22 Characters
Column C can only have a maximum of 22 Characters
Coumn D can only have a maximum of 14 Characters
The bit I can't quite get is how to make sure that excel goes to the nearest complete word that is <= to the maximum for that column, which I have preset in sheet2!A1:D1
I have tried alternatives of IF, LEN, MID and few more but can't quite seem to get it to work.
I can manage the first one using IF and LEN but it starts getting complicated after that and only being able to nest 7 times is a little restricting :o)