Substitute function to remove blank spaces

[ChristineJ]

I am using the substitute function to remove blank spaces in strings of text in cells AD187 and AD191, as follows:

In cell AD187

=SUBSTITUTE(C188," ","")&IF(I188="","x",I188)&IF(K188="","x",K188)&SUBSTITUTE(C189," ","")&IF(I189="","x",I189)&IF(K189="","x",K189)&SUBSTITUTE(C190," ","")&IF(I190="","x",I190)&IF(K190="","x",K190)&SUBSTITUTE(C191," ","")&IF(I191="","x",I191)&IF(K191="","x",K191)

In cell AD191

=AD188&AA188&"x"&SUBSTITUTE(AD189," ","")&"x"&AA189&SUBSTITUTE(AD190," ","")&"x"&AA190&"xx"

I need to compare the two results to see if they are the same, and am using if(AD187=AD191,444,0) to do so. It returns a 0 as if they are not the same, even when they are. Both cells show Cash612000xCommonStockx340000Paid-inCapitalinExcelssofPar-CommonStockx272000 What do I need to change in my formulas so that when compared with this IF function a 444 is returned?

However, if I copy the VALUES from AD187 and AD191 to other cells and use an IF function to compare them, it returns 444, indicating they do match one another.

Thanks!

 

[Peter_SSs]

Hard to tell without knowing exactly what is in all the precedent cells ( C188, I188, ...... , AA190)

 

[Special-K99]

Post the spreadsheet, remove any sensitive data, create a mockup example if necessary.

You cant attach files on this forum.
Uupload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[ChristineJ]

Yes, sorry to be unclear on that. As I was typing my response to you I had an idea and tried it - it worked!

Thanks for being willing to help me.