I’m trying to use the SUBSTITUTE function to get rid of emojis so I can have a “clean” version of some fields my client want to have as downloadable in .CSV

I need to have a formula with a bunch of substiutions, but I started from the very first and I get nothing but errors, formula atm looks like this:

SUBSTITUTE({Respuesta Pregunta 1},'✅','')

I realised the error has something to do with the type of field of {Respuesta Pregunta 1} as it is a lookup field, just for testing I created a single text field next to it, copy the data of the lookups to the new text field, applied the formula to the text field, and it works. So I’m suspecting SUBSTITUTE doesn’t work with lookups?

Any ideas to work this out?