I used FIND and MID to clean a dataset in Excel.
=FIND(":", B7, 60) etc.
=MID(B7, 88, (D7-C7)-1) etc.
When I link Access 2000 to Excel (2010), Access grabs every field correctly except the MID field. Access displays nothing in the MID column.
Any thoughts on why this might be, and how I can get the MID function to populate?
Thanks!