+ Reply to Thread
Results 1 to 2 of 2

formula or vba to trim clean description column from specific wording

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,049

    formula or vba to trim clean description column from specific wording

    I have a datasheet of 12000 description looking a formula to delete in columns B all description having the wording EUR1122333 with its numbers.


    Some have brackets and other not .

    Thanks if anyone can assist
    Attached Files Attached Files

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,094

    Re: formula or vba to trim clean description column from specific wording

    This should do:
    =IFERROR(TRIM(LEFT(B2,SEARCH("EUR",B2)-1)),B2)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] extract specific word from a description to a specific column
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-08-2018, 10:32 AM
  2. Count specific wording in column heading
    By morerockin in forum Excel General
    Replies: 5
    Last Post: 09-24-2016, 10:40 AM
  3. When TRIM() and CLEAN() fail.
    By fhalejr in forum Excel General
    Replies: 7
    Last Post: 01-02-2014, 02:12 AM
  4. A Sum If one column is a specific description it changes the value.
    By italianstallion in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2013, 03:26 AM
  5. Macro to delete column if it contains specific wording
    By swoods118 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2013, 01:16 PM
  6. Can't 'trim' or 'clean' spaces
    By hutch@edge.net in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2010, 07:06 PM
  7. Clean and Trim
    By tl7410 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2009, 03:03 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1