AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 1,835
- Office Version
- 2019
- 2016
- Platform
- Windows
I'm comparing a cell with a field in a recordset from Access.
The leading apostrophe is lost by Excel which I think then needs two apostrophes.
This really complicates the compare.. is there any way to set Excel to use the apostrophe as any other char ?
The leading apostrophe is lost by Excel which I think then needs two apostrophes.
This really complicates the compare.. is there any way to set Excel to use the apostrophe as any other char ?