ChristineJ
Well-known Member
- Joined
- May 18, 2009
- Messages
- 761
- Office Version
- 365
- Platform
- Windows
I am using the substitute function to remove blank spaces in strings of text in cells AD187 and AD191, as follows:
In cell AD187
In cell AD191
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!
In cell AD187
Code:
=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
Code:
=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!