Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I insert a symbol AT THE END of text for multiple cells in Excel?
I'm trying to add a double quotation at the end of all text entries in
a column and I have over 1000 entries. Can somebody tell me how do I do this? It would be much appreciated. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I insert a symbol AT THE END of text for multiple cells in Excel?
Thx for the promt response. I am quite a noobie when it comes to
excel. What do you mean by fix the reference in 3) Thx oteixeira wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I insert a symbol AT THE END of text for multiple cells in Excel?
"Fix the reference" means add $ signs to the cell reference to keep it Absolute
as opposed to Relative. See Help on this subject. Assuming G1 contains the " Column A contains the text entries. In B1 enter =A1 & $G$1 then double-click on the fill handle of B1 to copy down to end of data in Column A. The A1 will increment but $G$1 will not. When happy, select column B and copy. Paste Special(in place)ValuesOKEsc Clear the contents of G1 and delete Column A Gord Dibben MS Excel MVP On 19 Jun 2006 07:22:00 -0700, "doiley6167" wrote: Thx for the promt response. I am quite a noobie when it comes to excel. What do you mean by fix the reference in 3) Thx oteixeira wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need macro to delete all text cells in an Excel range | Excel Worksheet Functions | |||
how insert same text in empty cells in column (10000 rows) | Excel Worksheet Functions | |||
How can I Insert a Comment into multiple cells in Excel 2003? | Excel Discussion (Misc queries) | |||
insert text in a no. of cells of each sheet? | Excel Discussion (Misc queries) | |||
Adding a lot of text to MS Excel cells | Excel Discussion (Misc queries) |