Append same text to every cell in a column in Excel



  • 4 Answer(s)

    The best solution is here :

    • In a column A, all the data are here, beginning at row 1.
    • In column B, row 1, enter =A1&”,”
    • It will create cell B1 equal A1 along a comma appended.
    • Presently select cell B1 and drag from the bottom right of cell down via all the rows and this copies the syntax and uses the equivalent, column A value.
    Answered on January 7, 2019.
    Add Comment

    The following code is a simple “&” function:

    =cell&"yourtexthere"
    

    For example in cell says Mickey, but want Mickey Mouse. Mickey is in A2. In B2, type

    =A2&" Mouse"
    

    So, copy and “paste special” for the values.

    B2 now reads "Mickey Mouse"
    
    Answered on January 7, 2019.
    Add Comment

    Try this code :

    =CONCATENATE(A1,",")
    

    For example,  In A1 cell if [email protected] so write in another cell =CONCATENATE(A1,”,”)

    This [email protected] next using this formula and will have [email protected],

    For remove formula : copy that cell in additionally use alt+e+s+v or paste special value.

    Answered on January 7, 2019.
    Add Comment

    See if this works for you.

    • All your data is in column A (beginning at row 1).
    • In column B, row 1, enter =A1&”,”
    • This will make cell B1 equal A1 with a comma appended.
    • Now select cell B1 and drag from the bottom right of cell down through all your rows (this copies the formula and uses the corresponding column A value.
    Answered on March 5, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.