if true then copy initial cell to new cell

[4430salton]

Hello EF,

I am trying to write an if statement that can find certain text (in column A)and then copy the contents of cell Ax to cell XX. I am using the following with no success

=IF(A6="008*",C6=A6)

where am I going wrong? Thanks for any and all help!

the contents of column A comes from a copy of a PDF that I paste into excel. its made up of letters and numbers.

[vlady]

can you try

in cell XX=IF(ISERR(SEARCH("008*",A6)),"",A6)

[Ace_XL]

vlady's solution works, but you could also do away with the asterisk (*) in vlady's solution above

Hence,
=IF(ISERR(SEARCH("008",A6)),"",A6)

[vlady]

where did that asterisk came from ???

[Ace_XL]

From the OP's initial post I reckon

[vlady]

yeah just copied and pasted not looking briefly, hehehe.

[4430salton]

Thank you Vlady and ACE_XL that works! but I was wondering whether I need to ask a new question because what I ultimately need is for certain data to go to different cells. For example, the statement that is being evaluated is something like this "00678299 neverclosed 2012-07-12 more" and I need to extract the number 00678299 and date 2012-07-12 to separate columns/cells. If I need to do a new question that is not a problem, Thanks!