Hi,
I would like to find text start with INC in Column A and if found copy that row in to Column C.
Column A (something like this)
INC1234
TEST1234
<blank>
<blank>
TE
INC12345
INC23456
<blank>
<blank>
CK
INC5678
summer
So put this in Column C
=IF(LEFT(A1,3)="INC", A1,"")
That work for you?
Last edited by ChrisMattock; 11-27-2008 at 03:39 PM. Reason: Spelling!
Thank you this is working only if i drag down the formula.
in my case i have 2000+ line. i would still like to learn but this time i fould another way to do the report.
Thank you again for you help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks