How to insert newline in you excel formulae


To add a newline or a hard return in front of certain text, we try the Find & Replace option, but ends up nowhere. Instead make use of the CHAR(10), MS has provided, in your formulaes. Usage: =CONCATENATE("Heading1",CHAR(10),"Content under Heading1")   Let me take a complex example also, to get you the feel of the … Continue reading How to insert newline in you excel formulae

Setting screen width for Web sites to be viewed on iPhone


Fixing the width of the page in iPhone to a certain value is not direct. Safari is assuming an 800px width. The best solution to this is just by using the meta tags. Check the snippet below: To set the width to the screen width based on the mode he is in, be it landscape … Continue reading Setting screen width for Web sites to be viewed on iPhone