Please help with this special macro

[Guest]

Hi!

All i want is to take the value from the cell to the left from me
then i want to delete the first two sign/cacacters from this cell and take
the newvalue into my cell


hope someone can help

Regards alvin

 

[Bob Phillips]

=SUBSTITUTE(SUBSTITUTE(A21,"-",""),"+","")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Alvin,

Here give this formula a try. Let us say the information with the two
characters at the front of the text is in cell B8, in cell C8 you type this
formula:

=MID(B8,3,LEN(B8))


Or, if you want it in macro form for some reason, you could try this:

ActiveCell.FormulaR1C1 = "=MID(RC[-1],3,LEN(RC[-1]))"
ActiveCell.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

HTH

Tofer