Pasteing across multiple columns

[LEJ]

ozzie,

My sheet doesnt work like yours - why - I do not understand
You have values in the statements of 70 75 and 80 - I understand that 80 is the max width - what are 70 and 75?

I have attached my working sheet - it has other working columns for Useby dates etc....

http://www.mediafire.com/?89bed4cbdb1k4qm

What do you think??

LEJ
Sydney

[ozzie]

LEJ
I've put in my adjusted formula to suit the E column rather than the A column
I have also recopied your info further down and and changed the formula to get rid of the all of the error stuff caused by lack of data
I haven't done anything about the 'INSTRUCTIONS: Eat Cold' as it wasn't about ingredients and therefore didn't seem to require it !?

My formula uses the SEARCH function as the main working engine.
SEARCH(find " " space; text to search; start position)
The start position being important first looking for any spaces after 75 and if its less than 80, then use that, if not, look for a space after 70
If I looked first for a space after 70 there is the possiblity of entire words which could have fitted in this column having to go in the next and having a cumulative effect column wise.

Your worksheet only has 'one' row for me to look at so I hope I've it looks OK

Your sheet is returned at
http://www.mediafire.com/?b4t6b1je660z6xy
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

[LEJ]

Ozzie,

Hi - back again.

I have now filled in some of the E columns,
E3 to E6, E13, E16 to E18
It seems to be missing the second column, and it starts to get out of whack??

I've posted the filled in work sheet at
http://www.mediafire.com/?6hadptd4719ftb2

Is there a way to force a carriage return - eg. three spaces

This is E13
MICROWAVE: Remove lid, Heat on high for 2 minutes. Based on a 650watt microwave. STOVE TOP: Add soup to pot. Simmer on high for 3 minutes. INGREDIENTS: INGREDIENTS: Water, tomato crush, red kidney beans, chicken, onion, peas, celery, potatoes, carrots, macaroni, sugar, salt, vegetable oil, thickener maize (1422), parmesan cheese, natural flavours, garlic, food acid (330), mineral salt (509), dextrose, maltodextrin, yeast extracts, vegetable protein extracts, pepper, basil, flavour enhancer (627, 631)

Thanks
LEJ

[ozzie]

Hi LEJ
missing the second column - I think this happened when I increased the helper column number - my fault, apologies - repaired
out of whack - there is a bad mixture of word wrapping,column width and forced row height that hides rows of text and shows part of this in the top of the cells involved,I have tidied this up for you
with more row samples to work on I can get a better idea on what is wanted/needed,as I can now see that cooking instructions can be mixed in with ingredient list stuff so I have fixed formula to show all contents of 'E' column
E3 has 853 characters - well above the 800 limit that I had catered for so I have amended column 'AA' to take all the remaing characters no matter how many as they are just getting lost otherwise

I have posted the amended sheet at
http://www.mediafire.com/?0wuz08wx5hp4a3d

you mention carriage return (this can be done with =CHAR(10))
BUT when I read this I had this feeling that you don't want or need any formula at all just some advice on formatting your sheet as I have done in column 'E' on the above worksheet
-adjust column width to approx 13cm.
-highlight cells and menu/format/cells/alignment and tick 'wrap text automatically'
-highlight all rows menu/format/row/optimal height and tick 'default value'
If this is what you really want then columns F to AA can be deleted.
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

[greenorange]

This post has been somewhat of a revelation to me.