append text to each cell in excel

append text to each cell in excel

You can append any common text to each cell in excel using the following logic:

  * if you are having the content in cell A1, then type the following in B1 as,

    =A1&"text to append"



  for eg, if you want to append ";" at the end of each cell then copy paste the following code in the nearer (in B1),

  =A1&";"



for eg, if you want to append "-" at the beginning of each cell then copy paste the following code in the nearer (in B1),

    ="-"&A1&";"