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