keyboard Shortcut for the ½ character

RincewindWIZZ

Board Regular
Joined
Feb 22, 2005
Messages
73
Hi

I have some tedious data entry to do into a spreadsheet. Mostly text.
Every once in a while I have to use the 1/2 character in a string

So I can copy and paste the character from the clipboard (very quick)
but copy/paste gets used a lot anyway so then I have
- to stop typing. go find the 1/2 character and copy/paste (very slow); or
- insert symbol (which is a slow process)
I dont seem to be able to create a keyboard shortcut
I cant execute a macro in the middle of typing a row of text

I tried using autocorrect to change 1/2 into the half character and that's not bad but it only seems to work if there is a space in front of the 1
so
21/2 does not change but
2 1/2 becomes 2½ which is great

Any better suggestions?

TFAI
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

gravanoc

Board Regular
Joined
Oct 20, 2015
Messages
149
In your Autocorrect options, put the keyboard shortcut in ()'s, then type the 1/2 as normal.

Like this:
 
Last edited:

gravanoc

Board Regular
Joined
Oct 20, 2015
Messages
149
Actually, I see that might not work as you intended. Just re-read your post. You could type it with the parentheses and then go back and delete them, but that still wouldn't quite fix it. I'll see if I can find an alt solution.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,285
Office Version
365
Platform
Windows
You cannot run a macro whilst editing a cell, so creating a macro won't help.
The autocomplete is probably the best option, but your value will then be text, rather than a number.
 

gravanoc

Board Regular
Joined
Oct 20, 2015
Messages
149
As an aside, there is a non-Excel solution to this. You would need to understand how to use AutoHotkey or own, say, a programmable mouse. Then you could run a macro when you please.
 

RincewindWIZZ

Board Regular
Joined
Feb 22, 2005
Messages
73
. . . . You could type it with the parentheses and then go back and delete them, but that still wouldn't quite fix it. I'll see if I can find an alt solution.
hhhmmm autocorrect is fine when there is a leading space but when there is not . . . . () may be preferable as () dont appear anywhere else and I can globally delete them. Messy though
 

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,809
If you're typing text into a cell, and you want to insert the 1/2 symbol, hold down the Alt key, and press 0189 on the number pad (not the numbers on the top of the keyboard).
 

Watch MrExcel Video

Forum statistics

Threads
1,100,193
Messages
5,473,071
Members
406,845
Latest member
JohnR123

This Week's Hot Topics

Top