Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding to current cells
Hello,
Need help adding a charicter to the end of contents in the cell without overwriting the cell contents. Example - Cell has "81234/12" and I want to add another "/" after "12" so it reads "81234/12/". I have done this before but have forgotten - was thinking that I used the find and replace function? Thanks, Tom |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding to current cells
Tom wrote:
:: Need help adding a charicter to the end of contents in the cell :: without overwriting the cell contents. Example - Cell has "81234/12" :: and I want to add another "/" after "12" so it reads "81234/12/". I :: have done this before but have forgotten - was thinking that I used :: the find and replace function? :: :: Thanks, :: Tom You could use find and replace if all the end values are the same. If A1 is "81234/12" I'd put in A2 =(A1&"/") this should then display as you want to, then all you need to do is copy A2 and use PASTE SPECIAL and select VALUES to paste the value over the original formula (or to another location). -- RiTSo |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding to current cells
Try this macro:
Sub AddSlash() Dim cell As Range For Each cell In Selection If cell.Value < "" Then cell.Value = cell.Value & "/" Else: cell.Value = cell.Value End If Next cell End Sub Select the range in question and run the macro. Biff "Tom" wrote in message oups.com... Hello, Need help adding a charicter to the end of contents in the cell without overwriting the cell contents. Example - Cell has "81234/12" and I want to add another "/" after "12" so it reads "81234/12/". I have done this before but have forgotten - was thinking that I used the find and replace function? Thanks, Tom |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding to current cells
See also response in programming group which you multi-posted to.
Gord Dibben MS Excel MVP On 28 Jan 2007 10:40:54 -0800, "Tom" wrote: Hello, Need help adding a charicter to the end of contents in the cell without overwriting the cell contents. Example - Cell has "81234/12" and I want to add another "/" after "12" so it reads "81234/12/". I have done this before but have forgotten - was thinking that I used the find and replace function? Thanks, Tom |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding to current cells
Apologies.
Your posting in programming was NOT identical to this one. Gord On Sun, 28 Jan 2007 11:54:38 -0800, Gord Dibben <gorddibbATshawDOTca wrote: See also response in programming group which you multi-posted to. Gord Dibben MS Excel MVP On 28 Jan 2007 10:40:54 -0800, "Tom" wrote: Hello, Need help adding a charicter to the end of contents in the cell without overwriting the cell contents. Example - Cell has "81234/12" and I want to add another "/" after "12" so it reads "81234/12/". I have done this before but have forgotten - was thinking that I used the find and replace function? Thanks, Tom |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding to current cells
Thanks to all - Got exactly what I needed.
Tom On Jan 28, 3:08 pm, Gord Dibben <gorddibbATshawDOTca wrote: Apologies. Your posting in programming was NOT identical to this one. Gord On Sun, 28 Jan 2007 11:54:38 -0800, Gord Dibben <gorddibbATshawDOTca wrote: See also response in programming group which you multi-posted to. Gord Dibben MS Excel MVP On 28 Jan 2007 10:40:54 -0800, "Tom" wrote: Hello, Need help adding a charicter to the end of contents in the cell without overwriting the cell contents. Example - Cell has "81234/12" and I want to add another "/" after "12" so it reads "81234/12/". I have done this before but have forgotten - was thinking that I used the find and replace function? Thanks, Tom- Hide quoted text -- Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Adding 2 cells proplem | Excel Discussion (Misc queries) | |||
adding color to cells based on a formula | Excel Worksheet Functions | |||
how do i add the same text after current text in multiple cells | Excel Discussion (Misc queries) | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) |