View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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