If row in column contain word, insert text next column
Closed
Tony Tomison
Zohaib R
- Posts
- 1
- Registration date
- Wednesday November 7, 2012
- Status
- Member
- Last seen
- November 7, 2012
Zohaib R
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Related:
- If row in column contain word, insert text next column
- How to delete rows and columns in word - Guide
- Rows to columns in notepad++ ✓ - Forum - Excel
- Using VBA to find last non empty row: in column, in table - Guide
- Mac word insert check mark - Guide
- Word insert watermark - Guide
1 reply
Zohaib R
Nov 7, 2012 at 04:41 PM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Nov 7, 2012 at 04:41 PM
Hi Tony Tomison,
Insert this formula in Column C:
=ISNUMBER(SEARCH("proprietary",B1))
This will insert a TRUE in C1 if the B1 contains the text "proprietary".
Do reply with results.
Insert this formula in Column C:
=ISNUMBER(SEARCH("proprietary",B1))
This will insert a TRUE in C1 if the B1 contains the text "proprietary".
Do reply with results.