-
If cells in a column contain a value, input text into another column.
I have a lengthy report with values in column B. They are shape names with other appended info (234Triangle3, 563Square8, 195Circle6). If column B contains text Triangle, Circle, or Square, I want to input "Triangle", "Circle", "Square" into column E. If the text in column B doesn't contain 1 of the 3 conditions, I want to input "N/A" into column E instead. Any help is greatly appreciated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules