?macro help-insert copy-w/o overwriting what is already there
 

Hi- appreciate any help. I do not know how to do anything but record a macro.
I want to insert a number "454-2381 x" before an extension. Like I record
the macro in the first cell. then when I play it in the 2nd cell it
overwrite the extension that is there & puts in the same extension in the
first cell.
454-2381 x15394
15391
15363
15209
15211
Can anyone help me?? THANK YOU SO MUCH IN ADVANCE!! HARRIET

?macro help-insert copy-w/o overwriting what is already there
 

Hi Jim,

thanks tons for the reply!!

I did that & this is what I got:
454-2381 xDisplay Name

it replaced it with "Display Name"
Can ya help me more?

"harriet" wrote:

Hi- appreciate any help. I do not know how to do anything but record a macro.
I want to insert a number "454-2381 x" before an extension. Like I record
the macro in the first cell. then when I play it in the 2nd cell it
overwrite the extension that is there & puts in the same extension in the
first cell.
454-2381 x15394
15391
15363
15209
15211
Can anyone help me?? THANK YOU SO MUCH IN ADVANCE!! HARRIET

?macro help-insert copy-w/o overwriting what is already there
 

Why not just use a formula in an adjacent column something like

="454-2381 x" & A2

where the extension is in A2.

If you need a macro solution then I just need to know if you intend to
select the cells you want to update or is it all of the cells in the column
or ??? I assume it is the same phone number for each?
--
HTH...

Jim Thomlinson


"harriet" wrote:

Hi- appreciate any help. I do not know how to do anything but record a macro.
I want to insert a number "454-2381 x" before an extension. Like I record
the macro in the first cell. then when I play it in the 2nd cell it
overwrite the extension that is there & puts in the same extension in the
first cell.
454-2381 x15394
15391
15363
15209
15211
Can anyone help me?? THANK YOU SO MUCH IN ADVANCE!! HARRIET

?macro help-insert copy-w/o overwriting what is already there
 

Guess what JIm - the dumme (me) figured the other thing out.

Your just super - thanks for helping me out!!!

"harriet" wrote:

Hi Jim,

thanks tons for the reply!!

I did that & this is what I got:
454-2381 xDisplay Name

it replaced it with "Display Name"
Can ya help me more?

"harriet" wrote:

Hi- appreciate any help. I do not know how to do anything but record a macro.
I want to insert a number "454-2381 x" before an extension. Like I record
the macro in the first cell. then when I play it in the 2nd cell it
overwrite the extension that is there & puts in the same extension in the
first cell.
454-2381 x15394
15391
15363
15209
15211
Can anyone help me?? THANK YOU SO MUCH IN ADVANCE!! HARRIET