ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert symbol (https://www.excelbanter.com/excel-discussion-misc-queries/94827-insert-symbol.html)

Frank E

Insert symbol
 
I would like to insert the phase symbol (Alt 0216) using a button, macro or
what ever is the easiest. I want to do this in the middle of text. Thanks.

Nikki

Insert symbol
 

Copy the symbol you want to reuse, and then click AutoCorrect Options on
the Tools menu.
In the Replace box , type a unique sequence of characters for the text.
(Make sure you don't type a real word€”for example, use "infi" .)
Click in the With box, press CTRL+V to paste the copied text, and then click
Add. noe when you type infi it will converit it to your symbol.


"Frank E" wrote:

I would like to insert the phase symbol (Alt 0216) using a button, macro or
what ever is the easiest. I want to do this in the middle of text. Thanks.


Frank E

Insert symbol
 
Is there a way to insert a symbol pressing 1 key?

"Nikki" wrote:


Copy the symbol you want to reuse, and then click AutoCorrect Options on
the Tools menu.
In the Replace box , type a unique sequence of characters for the text.
(Make sure you don't type a real word€”for example, use "infi" .)
Click in the With box, press CTRL+V to paste the copied text, and then click
Add. noe when you type infi it will converit it to your symbol.


"Frank E" wrote:

I would like to insert the phase symbol (Alt 0216) using a button, macro or
what ever is the easiest. I want to do this in the middle of text. Thanks.


Frank E

Insert symbol
 
Nikki,
we gave it a try and it works great. Thank you!

"Nikki" wrote:


Copy the symbol you want to reuse, and then click AutoCorrect Options on
the Tools menu.
In the Replace box , type a unique sequence of characters for the text.
(Make sure you don't type a real word€”for example, use "infi" .)
Click in the With box, press CTRL+V to paste the copied text, and then click
Add. noe when you type infi it will converit it to your symbol.


"Frank E" wrote:

I would like to insert the phase symbol (Alt 0216) using a button, macro or
what ever is the easiest. I want to do this in the middle of text. Thanks.



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

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