Hi All,
Can't seem to find why this is happening.
I just received a Quickbooks data export to work with. In the Address column, the entire address appears to be merged in one cell. The issue I'm having is, when I highlight the cell, only the street address is showing up in the address bar. I can see the rest of the address in the cell but not in the formula.
I have concatenated the addresses in my other data set to do vlookups against the merged cells but it isn't working.
Does anyone have any ideas as to why the entire cell is not showing up in my formula bar?
Any help would be greatly appreciated.
Can't seem to find why this is happening.
I just received a Quickbooks data export to work with. In the Address column, the entire address appears to be merged in one cell. The issue I'm having is, when I highlight the cell, only the street address is showing up in the address bar. I can see the rest of the address in the cell but not in the formula.
I have concatenated the addresses in my other data set to do vlookups against the merged cells but it isn't working.
Does anyone have any ideas as to why the entire cell is not showing up in my formula bar?
Any help would be greatly appreciated.
