TOLL FREE: 1 855 TRUE SKY (878 3759)


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

Excel Tips

Combine Data From Multiple Cells to One

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

How do you combine data from multiple cells into one cell?

  1. Select the desired cell you want the combined data to appear in
  2. Enter in =[First Cell]&&[Second Cell]

If necessary, add any additional characters to separate the data

For example: We want to combine the Main Account with the Sub Account with “/” in separating the data.

We would simply put in =A2&”/”&B2

Combine multiple cells into one

3) Press Enter

combine multiple cells into one


True Sky button