Extract Word from String

[minhestrone]

My smartphone expense app exports tags all into one column in Excel. I want to automatically extract these tags into three different columns to see where I spend my money, if the purchase is necessary, and the form of payment, all to be analyzed. How do I do this from the data in the "Tags" column?

I realized that I can't do a simply MID and FIND for strings.

Question.jpg

[poorcloud]

If what your looking for is to simply split the tags into columns, why don't you just use the text to columns button and split it by commas.

[D_Rennie]

If you want to keep the inital row use code as is, if you want to replace the initial row with the 1st part of the split change all the numbers 2 to number 1

Please Login or Register  to view this content.

[D_Rennie]

LMAO took 5 min to write code that excel aready has a built-in function for. HAHAHAHAHA

The Built in idear is ALOT better

[jindon]

This is to start with.

Add other necessity/payment method to Case statement if needed.

Please Login or Register  to view this content.

[minhestrone]

Wow.. thanks jindon! That worked perfectly. Now I'm gonna try to tinker around with it for a bit. Awesome job!

[minhestrone]

The Test to Columns didn't work because the order of the "Tags" are random and there are not always three words in the "Tags" column.