View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Bruce Sinclair Bruce Sinclair is offline
external usenet poster
 
Posts: 169
Default 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