What's Up East Coast Column

Read all about it!

You got the lowdown in the column, now get the breakdown. (A very special THANK YOU to Diane Pullen from WUEC for making this column possible!)

ADVERTISE in the popular WUEC magazine and post your events for free! This full colour booklet has been around for over 5 years and several thousands of hard copies are printed and distributed bi-monthly in the Eastern Cape area.
Contact me TODAY to get your listing up. It costs less than you think!

        12 Sep 2016, 1:26 pm

        Excel Fast Track Tricks (Issue 65) by Tiamari

        I use Excel daily and I absolutely LOVE it. Here are some more ways to improve your Excel experience.

        SPLIT TEXT STRINGS INTO COLUMNS

        I am sure most people are not too keen on data capturing. So what happens if you are faced with Excel data that is all typed in long rows, instead of in columns?

        In Issue 62 (Do the Splits) I explained how to use formulas to split text lines into columns. I used the formulas LEFT, RIGHT and MID to extract data from a text string. The Text to Columns feature is an even easier way to split text entered in a single cell into columns.

        For example, if both first and last names have already been entered into a cell, use Text to Columns to split the names into 2 columns. Simply select the text, and from the Data tab on the ribbon, choose Text to Columns. (It is in the Data Tools group). The wizard will guide you through the simple 3-step process.

        COMBINE TEXT FROM MULTIPLE CELLS

        Occasionally you might need data in different columns to be combined into one.

        For example, if both first and last names have already been entered into different cells, you can combine the names into one cell. To do this you enter a formula with the ampersand symbol (‘&’) between the cell references.

        The formula =A1&A2&A3 will add the text in cell A1, A2 and A3 together. If you want to add a space between the text from each cell, enter your formula like this: =A1&” “&A2&” “&A3

        NEW TO EXCEL?

        If you’ve been reading my Excel tips and nothing makes sense, it is time for a lesson or two! I offer private training - just drop me an email.

        My email address is email@tiamari.com

        Happy Clicking!

            Showing all records: