One minute Excel Tutorial – Text to Coloumn

How to do it

Well that is not the only thing it does. Its powers go beyond just splitting data in different coloumns. It can literally convert text to numbers in coloumn as well. But well that is left for future tutorial

The application of this feature is however limited to delimiter or width etc. So you have to take care in this regard.

Paste Special Transpose from coloumn to row

Surely up to its name because Paste Special is regular Paste’s big brother on steroids and has numerous tricks up his sleeves worth noticing.

LEAVE A REPLY

Please enter your comment!
Please enter your name here