User Profile
woogiiboo
Copper Contributor
Joined Feb 27, 2023
User Widgets
Recent Discussions
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 number assigned. There is a number then a space and then a keyword. E.g. 1 니트 I want to somehow easily get rid of the numbers assigned to the keywords without having to manually delete them by hand. Do you have any good suggestions on how to go about it?
