Recently, I tried to build a formula in sheets to tell me whether or not a character in a specific position of a string was a number or not. Turns out that none of them were? Even though, plain as day… there they are. Numbers.
remove html
So, I do a lot of editing website data and HTML in Google Sheets. A lot of the time it’s a lot of old stuff that someone else populated, sometimes it’s been extracted from a vendor website, and it’s almost always in need of some sort of repair.