Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jan 2007
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have some cells (see below) containing * characters:

    **Tony
    Tony**
    To*ny
    *Tony

    I want to delete the * characters.

    When I try to do this with Find and Replace, it removes everything. It is obviously using the * as a wildcard.

    Any ideas please?

    Thanks in advance

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    You can use ~* in the find/replace dialog box to tell Excel that the * is a literal character and not a wildcard.

    [attachment=84883:Literal.png]
    Attached Images Attached Images

  3. #3
    Star Lounger
    Join Date
    Jan 2007
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You learn something new every day! Thank you so much.

  4. #4
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='GillHarding' post='786516' date='28-Jul-2009 19:57']I have some cells (see below) containing * characters:

    **Tony
    Tony**
    To*ny
    *Tony

    I want to delete the * characters.

    When I try to do this with Find and Replace, it removes everything. It is obviously using the * as a wildcard.

    Any ideas please?

    Thanks in advance[/quote]

    One other way using a formula

    assuming your data start from A1 to A10, place this formula in B2 and copy down
    =SUBSTITUTE(A1,"*","")

    copy the result in col B and do a paste special >> values into col A
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

Posting Permissions

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