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

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

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

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

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

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 -