TOLL FREE: 1 855 TRUE SKY (878 3759)

Blog

Read up for news, tips and tricks about budgeting, planning and forecasting.

Excel Tips

Excel Tip #7 – How do I Split Columns?

How do I Split Columns?

 

We’re getting back to basics with Excel- the tool we all love and hate.

1) Identify the item that separates the columns (for instance, # in the example below) and highlight the range of cells you would like to split in your spreadsheet.

Split Columns Excel

2) From the Data tab, in the Data Tools group, select Text to Columns formula

split columns excel

3) Select Next

split columns excel

4) Enter in the separator symbol (for example, #) and then select Next.

split columns excel

5) Select Finish.

split columns excel

 

Click here to view more tips and tricks.