damiencarl
New Member
- Joined
- Dec 4, 2017
- Messages
- 3
I have a set of names that all begin with the same 4 characters, but the remaining characters are variable (e.g. ABC1111, ABC2222, ABC3333...). Also, the names show up in variable columns within the thousands of lines of data (columns A-G). Is there a way to search the lines of data for variable string "ABC*" and return the entire name in a single column (G)?
<tbody>
</tbody>
A | B | C | D | E | F | G | H |
data | data | data | data | data | data | ABC1111 | ABC1111 |
data | data | data | data | data | ABC2222 | data | ABC2222 |
data | data | data | data | data | data | data | ABC3333 |
ABC4444 | data | data | data | data | data | data | ABC4444 |
<tbody>
</tbody>