Create shortcut to enter non-breaking spaces

[crg42]

I live in Jersey. Many names have French origins. To enter [such as] Le Claire, I have to enter Le/alt0160/Claire to ensure the name appears alphabetically under L and not C. De la Mare requires two alt0160 entries. Control+shift+space does not work.

I want to create my own shortcut to enter non-breaking spaces.

Any ideas?

 

[6StringJazzer]

A macro won't work because a macro can't run while the cell is open for editing. A macro to replace all space in a cell with non-breaking spaces might work, after you have typed in the name. Is there anything in the cell besides the last name?

EDIT:

    Selection.Replace What:=" ", Replacement:=Chr(160), LookAt:=xlPart

I am not following how the space affects your alphabetization. Excel should sort based on the ASCII code collating sequence regardless of whether the space in the middle is a normal space or a non-breaking space. The following example uses normal spaces.

ensure the name appears alphabetically under L and not C

Before sorting:

$scratch.xlsm
	A
1	Le Claire
2	De la Mare
3	Clooney
4	Clabber
5	Lamont
6	Loman
7	Macy
8	Moony
9	Davison
10	Dohan
Sorting

After sorting:

$scratch.xlsm
	A
1	Clabber
2	Clooney
3	Davison
4	De la Mare
5	Dohan
6	Lamont
7	Le Claire
8	Loman
9	Macy
10	Moony
Sorting