Skip to main content

Text to Columns in Excel

Today I will show you , how to use Text to Columns feature in Microsoft Excel.Many times we may need to split a space separated line to columns and use.With this text to column option you can easily split the words to separate columns.
Eg: I want to split the follwing text to separate columns.

If it is copied to Excel sheet , each line will occupy a row and fit into single column(Here it is column A).



To Split do the following.

 1. Select Data Tab from the menu bar. Select the range to split .Now click on Text to Columns as shown in figure














2. A popup windows will appear.Choose the delimited option and click next.















 3. Now 'Check' the space option and click next.(Here the word is separated by single space.If it is required to be separated by any other character , it can be chosen).















 4. If you do not want to change any data format click next.















Now click Finish.Your data is ready.Now here is the converted records.







Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

UNIX : How to ignore lines with certain names

Sometimes we need to ignore multiple lines with certain words and get the list out of the file. usually it will be a log file to read . The below grep command can be used to ignore multiple words present in a text file. Lets say the file contain $ cat list.txt apple orange apple banana papaya Now we need to ignore line with orange , banana and papaya . So we can use the below grep command. $ cat list.txt | grep -Ev "orange|banana|papaya" apple apple It will ignore lines with the words in -v part of grep.
Post a Comment
Read more

BlackBerry Torch 9810/9850

BlackBerry Torch 9850 BlackBerry Torch 9810 BlackBerry has added two new devices to its Torch range with 9810 and 9850.Both devices have 1.2Ghz processor with 768MB RAM, expandable storage via microSD card and features 3G,Wi-Fi, Bluetooth and NFC support along with what BlackBerry calls Liquid Graphics UI.The phone run BlackBerry OS7. which offers improved browsing , a document viewer and DivX/Xvid video playback support out of the box.They also have a 5MP AF cameras with image stabilization and 720p HD video recording.The Torch 9810 has a 3.2-inch touchscreen display, a slide-out QWERTY keyboard, an optical trackpad and 8GB onboard storage.The Torch 9850 comes with a 3.7-inch touchscreen display(BlackBerry's largest so far) along with an optical trackpad and 4GB internal storage.
Post a Comment
Read more

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.
Post a Comment
Read more