Here is a video that demonstrates the VBA macro recording and shows how to run the macro (Tip: If you have difficulties to see the video, try to maximise it from lower right corner):
Showing posts with label Text to Columns. Show all posts
Showing posts with label Text to Columns. Show all posts
Thursday, 7 February 2013
Excel VBA macros: How to record a VBA macro
It is a good idea to automatise time consuming routine tasks in Excel. You don't need to know how to implement VBA macros, because you can just record your tasks. In following example I record a macro that assumes that I have people's whole names listed in column A and want to split names (first name and last name) into columns A anB. This is good example when simple recorded macro can save you from doing this routine task all over again.
Here is a video that demonstrates the VBA macro recording and shows how to run the macro (Tip: If you have difficulties to see the video, try to maximise it from lower right corner):
Here is a video that demonstrates the VBA macro recording and shows how to run the macro (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:
Posts (Atom)