Line shift in cell with formula and &

**carl84** · 01-26-2015, 05:37 PM

Hi,

Im trying to display information from a product page like in the image. Its a simple "IF" formula to display information present in the product page in the product offering to clients. The formula has line shifts, and it works perfectly fine in a pc, but in mac, it appears without a line shift.

Does someone know how I can make a line shift between each "HVIS"? "HVIS" is the same as "IF". The ctrl + alt + enter does not work :-(

Skjermbilde 2015-01-26 kl. 22.15.38.png

**Richard Buttrey** · 01-26-2015, 05:54 PM

Have you tried Ctrl-Command-Return?

Or in a function try Chr(13) instead of Chr(10)

**carl84** · 01-27-2015, 05:06 PM

Hi,

Thanks for your help! Found it! Excel translated char(10) to the Norwegian word (not used to that), replacing 10 with 13 made the difference!

3rd day with mac after 25 years with pc (client demand), so I will probably be back with other questions later

**Richard Buttrey** · 01-27-2015, 06:11 PM

Originally Posted by carl84

Hi,

3rd day with mac after 25 years with pc (client demand), so I will probably be back with other questions later

...of that I have no doubt.

Been there and got too many T shirts.

I love the Mac for many things and use it frequently for other stuff but when it comes to Excel I try to avoid it. I find it a real pain particularly in the VBE area where the syntax is often different to Windows VBA and the editor is just not user friendly. I dread it when a client wants s Mac devlopment, even more when the same development has to work on both platforms.