Cayce Cookbook - Page Template

Concatenate Excel Cell Value

Things to be aware of:

  • The concatenation formula won't work if the receiving cell format is Text. Best to set the format of the receiving cell to General.
  • There are other methods for this, but this one doesn't limit the character count.

>Basic "No Spaces" prcedure for concatenating cells G3, H3 & I3:

  • Select the receiver cell (ie: J3)
  • In the formula bar type: =(G3&H3&I3) and hit Return.
  • The concatenated data shows in the receiver cell, but the receiver cell is still a formula.
  • Copy the cell/column of concatenated data and, in a new cell/column, perform a Paste Special, selecting "Values" as the control.
  • Perform a Fill/Series to carry the formula down a column.

To insert spaces between elements when concatenating cells G3, H3 & I3:

  • Select the receiver cell (ie: J3)
  • In the formula bar type: =(G3&" "&H3&" "&I3) and hit Return.
  • The concatenated data shows in the receiver cell, but the receiver cell is still a formula.
  • Copy the cell/column of concatenated data and, in a new cell/column, perform a Paste Special, selecting "Values" as the control.
  • Perform a Fill/Series to carry the formula down a column.