[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

 Pasteing across multiple columns Goto page Previous  1, 2
Author Message
LEJ
General User

Joined: 08 Feb 2012
Posts: 7

 Posted: Tue Feb 14, 2012 2:25 am    Post subject: 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

Joined: 29 Jul 2010
Posts: 390
Location: victoria

 Posted: Tue Feb 14, 2012 9:30 am    Post subject: 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
General User

Joined: 08 Feb 2012
Posts: 7

 Posted: Mon Feb 20, 2012 5:19 am    Post subject: Pasteing across multiple columns 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

Joined: 29 Jul 2010
Posts: 390
Location: victoria

greenorange
Newbie

Joined: 14 Feb 2012
Posts: 1

 Posted: Mon Feb 20, 2012 10:56 pm    Post subject: This post has been somewhat of a revelation to me.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 HoursGoto page Previous  1, 2 Page 2 of 2

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum