copy-paste text formula

[pafian777]

hi guys,i need to ask for a formula which can copy paste A1:A10 values IF B1 is a number to D1:D10 in text,thanks so much!

[FDibbins]

Formulas cannot copy/paste anything anywhere, all they can do is function in the cell they reside it. Having said that, this should do what you want...
D1=IF(ISNUMBER($B$1),A1,"")
copied down

[pafian777]

thanks,is there any way that it can pasted text?? i need text,

maybe if we use a combination with another formula..?

[FDibbins]

=if(isnumber($b$1),a1&"","")

[pafian777]

unfortunatly n0,i need when it pasted to be on;y value not formula,thanks for the try

[pafian777]

like that E1

[FDibbins]

I have already told you that a formula cannot copy or past anything anywhere, you will need VBA for that

Alternatively, you can use my formula, then manually copy/paste values

[pafian777]

can you help me with one vba? please