Excel 4

[drfads07]

Is there a way where you could display both the formula and its out put in the same cell.

For instance:

I am using a "substitution" formula which removes dashes from numbers- I want the output of that formula to be displayed in the same cell.

OR:

If there is a way excel can automatically format a cell when i paste something into it. Please help..


Regards

 

[drfads]

I did try it bit seems like I am not doing it rite, will post comments after further testing.

Going back I really think I need some kinda invoke script like
when Selection.paste in a range automatically run macro. See if you can point me into a direction. Thanks

 

[bacon4life]

I haven't found anything in excel that captures paste events. In the user forms, there is a BeforeDropOrPaste but I am not sure that would work for you.

An alternate solution would be to replace ctrl-V with a macro.

Save this macro in the module1 section of the VBA editor. Then in excel, on the macro dialog box there is an options button that allows you to assign keys to the macro.

Sub RemoveDashes()
Dim X As Variant
Dim mycell As Range
ActiveSheet.Paste
For Each mycell In Selection
    X = mycell.Value
    X = Replace(X, "-", "", 1)
    'The next line puts the cleaned up data back in mycell
    mycell.Value = X
Next mycell
End Sub