Results 1 to 3 of 3
  1. #1
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    Madrid
    Posts
    758
    Is there a way to remove everything in a field after a certain character using excel or anything else.

    It's from a feed that has this format:

    Product name #85423
    Product Name2 #84216
    Product Name3 #51354
    etc..

    I want to get rid of everything after #

    TIA,
    Javi

    -------------
    <font size="1">Ladies and Gentleman you are being robbed every day, you know it and you're not doing anything about it. When is enough, enough? </font>

  2. #2
    ABW Ambassador sjangro's Avatar
    Join Date
    January 18th, 2005
    Location
    Boston
    Posts
    1,529
    Javi,

    Assuming there's only one # in the string and the string is in A1, try this:

    =LEFT(A1,FIND("#",A1))

    If you don't want the # in resulting string, you can use this:

    =LEFT(A1,FIND("#",A1)-1)

    If there's always a space before the # and you want to get rid of that too, change the -1 to a -2, or wrap the whole thing in a TRIM:

    =TRIM(LEFT(A1,FIND("#",A1)-1))

    --scott

    --
    scott@befree.com
    AOL/Yahoo: sjangro

  3. #3
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    Madrid
    Posts
    758
    Cool Scott, that worked.

    Thnx!

    -------------
    <font size="1">Ladies and Gentleman you are being robbed every day, you know it and you're not doing anything about it. When is enough, enough? </font>

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Excel Character Limitations
    By tfftff in forum WebMerge (Fourthworld.com)
    Replies: 2
    Last Post: August 10th, 2007, 02:49 AM
  2. What movie character are you?
    By Cagles Mill in forum Virtual Family and Off-Topic
    Replies: 32
    Last Post: March 24th, 2006, 02:09 PM

Posting Permissions

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