Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Move text that is a specific color to a different cell | Excel Worksheet Functions | |||
Copy from a Cell to a text box. | Excel Worksheet Functions | |||
Count items when specific text and date criteria are met | Excel Worksheet Functions | |||
CONDITIONAL FORMATING FINDING TEXT CONTAINING SPECIFIC NUMBERS | Excel Worksheet Functions |