Following video demonstrates how to import that text to Excel's columns easily (Tip: If you have difficulties to see the video, try to maximise it from lower right corner):
Wednesday, 6 February 2013
How to import text and use Excel's Text to Columns -feature
Normally, when you paste text to Excel, the whole text will appear in one column. Luckily Excel has nice feature called Text to Columns. With that feature you can spread your text data to columns nice and easy. In my example, I have text where items are delimited with commas and colons.
Following video demonstrates how to import that text to Excel's columns easily (Tip: If you have difficulties to see the video, try to maximise it from lower right corner):
Following video demonstrates how to import that text to Excel's columns easily (Tip: If you have difficulties to see the video, try to maximise it from lower right corner):
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment