Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Gloucester
    Posts
    28

    Unanswered: Special characters

    Hi got a slight problem

    I have some records which are file numbers
    A271A
    A271B
    A271C
    etc

    I need to edit them to
    A271(A)
    A271(B)
    A271(C)
    etc

    When I come to (C) or (R) I get the special characters -
    copyright character or
    Registered character

    How do I switch these off

    Its driving me mad

    all help taken with a large scotch

    cheers

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    To get use A271 (A)
    Use

    "A271" & Chr(40) & "A" & chr(41)

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Again

    To get A271 (A)

    Use

    "A271" & Chr(40) & "A" & chr(41)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •