hello,

I am trying to only obtain the value of a cell and not the formula.

For example:

lets say that in A1 I have :
=MID(CELL("Filename",A28),FIND("[",CELL("Filename",A28),1)+1,(FIND("xls",CELL("File name",A28),1)+1)-(FIND("[",CELL("Filename",A28),1)-1))

This gives me: G3 Product Spec_sheet_V6.1.xls


so what i want is to copy A1 to B1 but without getting the formula just the
value.
I do not want to copy and paste special..

What i need is to say something like =getvalue(A1).. and just gives me G3
Product....

Can anyone help?