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 |
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 |
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 |
All times are GMT +1. The time now is 07:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com