I have a column which is very likely to have 0 or 1 space in the middle of it. I would like to remove it. A1 is the column while these forumulas are in A2, A3
=UPPER(TRIM(A1)) =REPLACE(A2,FIND(" ",A2),1,"")
The problem is with find. I suspect it finds no space and errors. The below is my result. How do I delete all spaces in a row? or delete at least one space in the middle of the row?
123456 123456 #VALUE! 123 456 123 456 123456