Microsoft Excel Tips & Tricks
October 22nd, 2009 | by amdTaufik |This past few days, I’ve been busy editing a Microsoft Excel spreadsheet which contain 60,000 of rows. Its tough, but Ms Excel have its tips and tricks. Here are some of its that I’m using to simplified my work.
To combine data from 2 column
Assuming Column
A1 – word
B1 – press
To make column C1 contain the wordpress
Simply use this syntax =A1&B1
If you like spaces between the data =A1&” “&B1
To create hyperlink from Ms Excel colum
Assuming Column
A1 – http://www.amdtaufik.com/malaysia
B1 – Malaysia Travel Guide
To make column C1 a hyperlink entry with appropriate name
Simply use this syntax =HYPERLINK(A1,B1)
No related posts.
