Forum Discussion
Solved
How to divide text using text-to-column in this situation
I'm trying to look up how many times a specific keyword (in column G) appears in the table (B5:E15) using the =Countif function, but and as you can guess, the keywords in the table have a numbe...
If you want to keep the numbers, you could use
=COUNTIF(B4:E14, "*"&H4)
To get rid of the numbers, you could do the following:
In B16, enter the formula
=MID(B4, FIND(" ", B4)+1, 100)
Fill to the right to E16, then down to row 26.
Select B16:E26.
Copy this range, then paste as Values to B4.
You can then clear B16:E26, it is not needed anymore.
If you want to keep the numbers, you could use
=COUNTIF(B4:E14, "*"&H4)
To get rid of the numbers, you could do the following:
In B16, enter the formula
=MID(B4, FIND(" ", B4)+1, 100)
Fill to the right to E16, then down to row 26.
Select B16:E26.
Copy this range, then paste as Values to B4.
You can then clear B16:E26, it is not needed anymore.