Hi All, I have extracted a stock report from MYOB (into Excel) so I can manipulate it and upload the stock info to our new POS system. My issue is that our new barcode printer has an item description limit of 24 characters per line. (The barcode printer prints our retail price tickets and the ticket format has a limit of characters 24, including spaces), therefore I need to know where the text will wrap/break so I can rewrite each line so that our tickets display enough readable information for our customers.
eg. This is currently how one of the stock item cells reads, it's a designer kitchen tap with a pull out hose: "Slim D30 Kitchen Mixer Side Lever with Pull Out Spray".
I need to find out if Excel has a formula that I can use to force a line break at the 24th character (in every cell in 1 column), so it ends up looking like this:
"Slim D30 Kitchen Mixer S
ide Lever with Pull out
Spray"
Or like this:
"Slim D30 Kitchen Mixer
Side Lever with Pull Out
Spray"
Thank you in advance! I urgently need your advice. My deadline is 13 June 2015. :/
Cheers, DJ
eg. This is currently how one of the stock item cells reads, it's a designer kitchen tap with a pull out hose: "Slim D30 Kitchen Mixer Side Lever with Pull Out Spray".
I need to find out if Excel has a formula that I can use to force a line break at the 24th character (in every cell in 1 column), so it ends up looking like this:
"Slim D30 Kitchen Mixer S
ide Lever with Pull out
Spray"
Or like this:
"Slim D30 Kitchen Mixer
Side Lever with Pull Out
Spray"
Thank you in advance! I urgently need your advice. My deadline is 13 June 2015. :/
Cheers, DJ