How to ignore spaces in between the text as i want to compare and get the result that both are equal.
LEFT, MID,TRIM,RIGHT do not help
Address1- 811 Crestview Rd (Here 1 space betn 811 and Crestview)
Address2- 811 Crestview Rd (Here 2 spaces between 811 and Crestview)
So how to ignore the spaces in between and yield the result that text is equal