| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
char 124 where is on my keyboard.
I am having trouble finding some obscure characters on my keyboard.
I need the character 124 for example to specify this as a delimiter in the text to columns wizard for some data i am importing into excel. so this doesnt happen again with some other character, after i get the answer from one of you clever people, could you also tell me pls how to link a particular character or character code with its location on the keyboard so i can access it. many thanks -- Peter |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
char 124 where is on my keyboard.
Peter,
Shift+\ the \ sysmbol is to the left of the Z key. Mike "Peter" wrote: I am having trouble finding some obscure characters on my keyboard. I need the character 124 for example to specify this as a delimiter in the text to columns wizard for some data i am importing into excel. so this doesnt happen again with some other character, after i get the answer from one of you clever people, could you also tell me pls how to link a particular character or character code with its location on the keyboard so i can access it. many thanks -- Peter |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
char 124 where is on my keyboard.
hi
for future reference... in a blank workbook, in cell A1, enter..... =char(row()) then copy down to row 255. Regards FSt1 "Peter" wrote: I am having trouble finding some obscure characters on my keyboard. I need the character 124 for example to specify this as a delimiter in the text to columns wizard for some data i am importing into excel. so this doesnt happen again with some other character, after i get the answer from one of you clever people, could you also tell me pls how to link a particular character or character code with its location on the keyboard so i can access it. many thanks -- Peter |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
char 124 where is on my keyboard.
Peter wrote on Tue, 8 Jul 2008 04:49:00 -0700:
I need the character 124 for example to specify this as a delimiter in the text to columns wizard for some data i am importing into excel. so this doesnt happen again with some other character, after i get the answer from one of you clever people, could you also tell me pls how to link a particular character or character code with its location on the keyboard so i can access it. many thanks The symbols are probably marked on the keys above and to the right of the alphabetics, so just enter ALT+0124 (number pad) and see what you get. -- James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
char 124 where is on my keyboard.
In the "other" delimiter box enter the character by holding Alt key and typing
0124 on the numpad. Gord Dibben MS Excel MVP On Tue, 8 Jul 2008 04:49:00 -0700, Peter wrote: I am having trouble finding some obscure characters on my keyboard. I need the character 124 for example to specify this as a delimiter in the text to columns wizard for some data i am importing into excel. so this doesnt happen again with some other character, after i get the answer from one of you clever people, could you also tell me pls how to link a particular character or character code with its location on the keyboard so i can access it. many thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
char 124 where is on my keyboard.
taa!
-- Peter "Gord Dibben" wrote: In the "other" delimiter box enter the character by holding Alt key and typing 0124 on the numpad. Gord Dibben MS Excel MVP On Tue, 8 Jul 2008 04:49:00 -0700, Peter wrote: I am having trouble finding some obscure characters on my keyboard. I need the character 124 for example to specify this as a delimiter in the text to columns wizard for some data i am importing into excel. so this doesnt happen again with some other character, after i get the answer from one of you clever people, could you also tell me pls how to link a particular character or character code with its location on the keyboard so i can access it. many thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
char 124 where is on my keyboard.
thankyou!
-- Peter "James Silverton" wrote: Peter wrote on Tue, 8 Jul 2008 04:49:00 -0700: I need the character 124 for example to specify this as a delimiter in the text to columns wizard for some data i am importing into excel. so this doesnt happen again with some other character, after i get the answer from one of you clever people, could you also tell me pls how to link a particular character or character code with its location on the keyboard so i can access it. many thanks The symbols are probably marked on the keys above and to the right of the alphabetics, so just enter ALT+0124 (number pad) and see what you get. -- James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
char 124 where is on my keyboard.
thankyou!
-- Peter "FSt1" wrote: hi for future reference... in a blank workbook, in cell A1, enter..... =char(row()) then copy down to row 255. Regards FSt1 "Peter" wrote: I am having trouble finding some obscure characters on my keyboard. I need the character 124 for example to specify this as a delimiter in the text to columns wizard for some data i am importing into excel. so this doesnt happen again with some other character, after i get the answer from one of you clever people, could you also tell me pls how to link a particular character or character code with its location on the keyboard so i can access it. many thanks -- Peter |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
char 124 where is on my keyboard.
taa muchly!
-- Peter "Mike H" wrote: Peter, Shift+\ the \ sysmbol is to the left of the Z key. Mike "Peter" wrote: I am having trouble finding some obscure characters on my keyboard. I need the character 124 for example to specify this as a delimiter in the text to columns wizard for some data i am importing into excel. so this doesnt happen again with some other character, after i get the answer from one of you clever people, could you also tell me pls how to link a particular character or character code with its location on the keyboard so i can access it. many thanks -- Peter |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
char 124 where is on my keyboard.
In article , ?B?RlN0MQ==?= wrote:
hi for future reference... in a blank workbook, in cell A1, enter..... =char(row()) then copy down to row 255. ... and try that with different fonts too :) Regards FSt1 "Peter" wrote: I am having trouble finding some obscure characters on my keyboard. I need the character 124 for example to specify this as a delimiter in the text to columns wizard for some data i am importing into excel. so this doesnt happen again with some other character, after i get the answer from one of you clever people, could you also tell me pls how to link a particular character or character code with its location on the keyboard so i can access it. many thanks -- Peter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
| CHAR(10) = ALT+ENTER?? | Excel Worksheet Functions | |||
| How do I get around the 255 char limit? | Links and Linking in Excel | |||
| 8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
| CHAR(10) | Excel Worksheet Functions | |||
Linear Mode
