Excel : Join strings from two cells

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

Comments

UNIX : How to get record count from zipped file

Sometimes we may need to get records count from file . For that we can use wc -l , command with file name. In some situation the file will be in compressed format . wc -l will not directly work with zipped files . In this case we can do zcat the file and pipe the word count command with it. Example : Let say we have a file cricketData.dat.gz To get word count from the file use : zcat cricketData.dat.gz | wc -l This will give the record count.

Scala

Scala is a object oriented functional type programing language. All variables declared in scala is considered as objects.

Excel : How to pad zeros

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")

Tech Info Talks

Search This Blog