|
|
#6
02-28-2024, 10:37 AM
|
|||
|
|||
Shelley Lou, If I correctly understand your aims, I'd use characters, not words because of the MS Office's unusual idea of a word.
Since I have no opportunity to test the following, try experimenting with the code: Code:
If sLastWord = "]" Then msgbox sLastWord.range.characters.first.previous 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| IFS query (I think) | ronsar | Excel | 1 | 12-06-2018 09:04 AM |
 Conditional query ...
|
LearnerExcel | Excel | 5 | 02-06-2018 01:13 AM |
| Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |
|
Baseline query
|
joday48 | Project | 6 | 01-25-2013 09:50 AM |
| How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? | mag | Excel | 0 | 10-18-2012 11:15 AM |
Windows 7 64bit 
Office 2016
Threaded Mode