Append same text to every cell in a column in Excel

Question

How can I append text to every cell in a column in Excel  I need to add a comma       to the end   Example    email address com turns into email address com   Data Sample   m2engineers yahoo co in satishmm 2sptc yahoo co in threed precisions rediffmail com workplace solution yahoo co in threebworkplace dataone in dtechbng yahoo co in innovations yahoo co in sagar mmm com bpsiva mmm com nsrinivasrao mmm com pdilip mmm com vvijaykrishnan mmm com mrdevaraj mmm com b3minvestorhelpdesk mmm com sbshridhar mmm com balaji mmm com schakravarthi mmm com srahul1 mmm com khramesh2 mmm com avinayak mmm com rockindia hotmail com

User · Accepted Answer

See if this works for you      All your data is in column A  beginning at row 1   In column B  row 1  enter       A1 amp     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   Select the newly appended data  copy it and paste it where you need using Paste - gt  By Value   That s It

User · Answer

It s a simple  quot  amp  quot  function   cell amp  quot yourtexthere quot   Example - your cell says Mickey  and you want Mickey Mouse  Mickey is in A2  In B2  type  A2 amp  quot  Mouse quot   Then  copy and  quot paste special quot  for values  B2 now reads  quot Mickey Mouse quot

User · Answer

It s simple     CONCATENATE A1   quot   quot    Example  if email address com is in the A1 cell then write in another cell   CONCATENATE A1   quot   quot   email address com    After this formula you will get   email address com  For remove formula  copy that cell and use Alt   E   S   V or paste special value

User · Answer

Select the range of cells  type in the value and press Ctrl   Enter  This  of course  is true if you want to do it manually

User · Answer

Type it in one cell  copy that cell  select all the cells you want to fill  and paste  Alternatively  type it in one cell  select the black square in the bottom-right of that cell  and drag down

User · Answer

There is no need to use extra columns or VBA if you only want to add the character for display purposes    As this post suggests  all you need to do is    Select the cell s  you would like to apply the formatting to Click on the Home tab Click on Number Select Custom In the Type text box  enter your desired formatting by placing the number zero inside whatever characters you want    Example of such text for formatting    If you want the cell holding value 120 00 to read  120K  type  0K

User · Answer

Put the text value in the first cell  then copy the cell  mark the whole colum and  paste  the copied text value    This works in Excel 97 - sorry no other version available on my side

User · Answer

I just wrote this for another answer  You would call it using the form using your example  appendTextToRange  quot  theRange  quot    quot   quot   Sub testit       appendTextToRange  quot A1 D4000 quot    quot hey there quot  End Sub   Sub appendTextToRange rngAddress As String  append As String       Dim arr   As Variant  c As Variant     arr   Range rngAddress  Formula      For x   LBound arr  1  To UBound arr  1          For y   LBound arr  2  To UBound arr  2              Debug Print arr x  y              If arr x  y     quot  quot  Then                 arr x  y    append             ElseIf Left arr x  y   1     quot   quot  Then                 arr x  y    arr x  y   amp   quot   amp   quot  quot   quot   amp  append  amp   quot  quot  quot  quot              Else                 arr x  y    arr x  y   amp   quot   quot   amp  append             End If         Next     Next     Range rngAddress  Formula   arr  End Sub

User · Answer

Highlight the column and then Ctrl   F  Find and replace Find  quot  com quot  Replace  quot  com   quot  And then one for  in Find and replace Find  quot  in quot  Replace  quot  in   quot

User · Answer

Pretty simple   you could put all of them in a cell using the concatenate function   CONCATENATE A1   quot    quot   A2   quot    quot   and so on

User · Answer

Simplest of them all is to use the  quot Flash Fill quot  option under the  quot Data quot  tab   Keep the original input column on the left  say column A  and just add a blank column on the right of it  say column B  this new column will be treated as output    Just fill in a couple of cells of Column B with actual expected output  In this case        m2engineers yahoo co in        satishmm 2sptc yahoo co in    Then select the column range where you want the output along with the first couple of cells you filled manually     then do the magic   click on  quot Flash Fill quot     It basically understands the output pattern corresponding to the input and fills the empty cells

[excel] Append same text to every cell in a column in Excel

Examples related to excel

Examples related to excel-2007