PowerRotmg

u/PowerRotmg


r/googlesheets•

The sheet in question

I want to extract the number to the left of a given phrase within a cell.

The O1 cell contains pasted data, the phrase I want to find is the phrase in column B, and I want to display the number left of the phrase into cell C.

Ex: The first rows phrase, Acidic Slasher, has 3 to the left within the O1 cell, and displays 3 in the C cell.

I did figure out a way to do this, but I couldn't find out how to reference the phrase cell inside the function. Instead I needed to type the phrase into the equation myself.

If there's a better way to do this entirely, that would b

11


r/forsenpasta•

Do me a favor if you're not following the channel get the fuck the out of here forsenCD go go skooter skoot skoot on your skooter go go go back to 🇸🇪 forsenGa go back to your reddits forsenCD

80