ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel help! (https://www.excelbanter.com/excel-worksheet-functions/40112-excel-help.html)

Excel help!

Excel help!
 
I want to get the value of a cell like the next.
Example.
The value of A1 cell is '—‹. It will display the —‹ only in the document.
Question:
I want get the '—‹. How to do? I can only get the —‹ by the Text and
value property.

Alan

Use two apostrophes
''? will display '?
Regards,
Alan.
"Excel help!" <Excel wrote in message
...
I want to get the value of a cell like the next.
Example.
The value of A1 cell is '?. It will display the ? only in the document.
Question:
I want get the '?. How to do? I can only get the ? by the Text and
value property.





All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com