ExcelBanter - PrefixCharacter

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - PrefixCharacter (https://www.excelbanter.com/excel-programming/356200-prefixcharacter.html)

Gary''s Student

PrefixCharacter

How do I change the default PrefixCharacter in a worksheet from a single
quote (apostrophe) to another character?

I need to process text records that may begin with a single quote.

Thanks in Advance
--
Gary's Student

Tom Ogilvy

PrefixCharacter

I believe you will have to process them after the fact, testing for a
prefixcharacter.

--
Regards,
Tom Ogilvy

"Gary''s Student" wrote:

How do I change the default PrefixCharacter in a worksheet from a single
quote (apostrophe) to another character?

I need to process text records that may begin with a single quote.

Thanks in Advance
--
Gary's Student

All times are GMT +1. The time now is 12:12 PM.