Is there any formula to split a string and combine integer values from the string in GOOGLE SHEET?-CodePudding

Home > Net > Is there any formula to split a string and combine integer values from the string in GOOGLE SHEET?

Is there any formula to split a string and combine integer values from the string in GOOGLE SHEET?

Time：07-17

So I'm making a list for buying groceries in google sheet as follows.

0.95 - Lemon Juice

2.49 - Pringle Chips

1.29 - Baby Carrots

9.50 - Chicken Kebab

What I'm trying to do is split "-" and combine the all costs (0.95 2.49 1.29 9.50).

I've tried to use Index(SPLIT(B22,"-"), 7) or SPLIT(B22,"-") but I don't know how to take only float points from the split string.

Does someone know how to do this? Here's the