You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
it's probably not as performant but I prefer the "apply a function, then add zero to the result" to get you a 1 or 0.
Ultimately though, this is 81 records with an error which could/should have been solved just by editing the cell with the error.
I think the question here is:
how do you edit cells without physically interacting with them?
would a replace work?
=REPLACE(A2,1,LEN(A2),A2)
yes. yes it would.