Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help with this special macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help with this special macro
=SUBSTITUTE(SUBSTITUTE(A21,"-",""),"+","")
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "alvin Kuiper" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help with this special macro
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 "alvin Kuiper" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PASTE SPECIAL w/ Macro | Excel Discussion (Misc queries) | |||
macro to sum special to new sheets. | Excel Programming | |||
I need help with creating a special macro . | Excel Worksheet Functions | |||
Special macro | Excel Programming | |||
Macro to Paste Special | Excel Programming |