View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
oteixeira
 
Posts: n/a
Default How do I insert a symbol AT THE END of text for multiple cells in Excel?


Hello.
1.Just write the double quotation in a empty cell.
2.In a column in front of your data enter a formula:

+<The first cell of your data range&<Cell where you wrote the double
quotation
3.Fix ($) the reference to the cell containing the double quotation.
4.Copy this cell until the end of your data.
5.Don't forget to transform you new data in Values.

Hope this helps


--
oteixeira
------------------------------------------------------------------------
oteixeira's Profile: http://www.excelforum.com/member.php...o&userid=35320
View this thread: http://www.excelforum.com/showthread...hreadid=553224