Tech Info Talks

Today I got a requirement to format the number in excel cell - to left pad number with zeros.i find the following function very useful to do it. In case one to make the number left padded with "0" s give the formula =TEXT(A1,"0000") In case two even more enhanced form to make it left padded with "0" and add two decimal places give the formula as =TEXT(A2,"0000.00")

To concatenate two cells to one cell and have them in two different line use the below technique. Lets say A1 has This is line one B1 has This is line two To have C1 as  This is line one This is line two  give =CONCATENATE(A1," ",B1) To have C1 as This is line one                         This is line two  give =A1&CHAR(10)&B1