View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
timmulla timmulla is offline
external usenet poster
 
Posts: 46
Default Finding specific text in ranges

I have a spreadsheet with data in columns G and H. Can anyone help me create
code that will loop through columns G and H and if it finds specific text in
either column, it will put the text "403 B" in column in column I. To make
things complicated the specific text in column G is just a small peace of
text in a larger sentence. The specific text in column G will be the entire
contents in the cell.

Specific text in column G:

403-B
403B
403(B)(7)
403(B)
403 (B)(7)
403B-7
403B7
403(B)(7)-PERSHING

Specific text in column H:

403-B GROUP
403-B INDIVIDUALLY ESTAB
K through 12 403 (B)
403(B)
403(b) Retirement Plan For Non-Profit Organizations
403-B SALARY REDUCTION
403-B SCHOOL DISTRICTS
501 (C) Other 403 (B)
SPAC 403-B GROUP
Non-Qualified 403(B)
TSA 403 (B)
TSA/403(b)(7)

Any help would be apppreciated.

--
Regards,

timmulla