Hi,
I have a spreadsheet that for some unknown reason certain users love merging cells. We're in the process of stamping out that practice, but in the meantime as part of an import and VLOOKUP I need to be able to removed the merged calls.
The cells are G and H on the sheet and contain...