Results 1 to 3 of 3

Thread: Concatenate?

  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: Concatenate?

    I have a list of Values that resemble something like this

    WP0CA2993IS652145

    Unfortunatly data input error has added a O where the 0 should be.

    Ex. WPOCA2993IS652145

    Can I use a Concatenate to change this or eliminate it so I can do Vlookups or some other type of search with it?

  2. #2
    Join Date
    Mar 2004
    Posts
    361
    I am using a MID function to get rid of the WPO but when I copy the formula down, it shrinks the cell above it?

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    Try the Substitute function
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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