AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 2,099
- Office Version
- 2019
- 2010
- Platform
- Windows
How do you detect if text in a cell starts with a leading apostrophe ? TIA.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Identify cells with leading apostrophe via VBA
- Thread starter AlexanderBB
- Start date
-
- Tags
- apostrophe cell leading starts text
AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 2,099
- Office Version
- 2019
- 2010
- Platform
- Windows
Re: One last try... can anyone answer this
His code had a comma. I was trying to adapt it to my situation, but yes it's the same issue.
His code had a comma. I was trying to adapt it to my situation, but yes it's the same issue.
Upvote
0
Excel Facts
Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 2,099
- Office Version
- 2019
- 2010
- Platform
- Windows
Re: One last try... can anyone answer this
It is the apostrophe. That routine showed up when searching for help, and might have been some use.
This was quite good - https://excelribbon.tips.net/T010675_Searching_for_Leading_Apostrophes.html
It is the apostrophe. That routine showed up when searching for help, and might have been some use.
This was quite good - https://excelribbon.tips.net/T010675_Searching_for_Leading_Apostrophes.html
Upvote
0
Similar threads
- Solved
- Question
- Solved
- Question
