+ Reply to Thread
Results 1 to 6 of 6

Remove unwanted text/ numbers from name

  1. 05-13-2014, 12:42 PM #1
    MATU70
    MATU70 is offline
    Registered User
    Join Date
    01-16-2014
    Location
    uk
    MS-Off Ver
    Excel 2013
    Posts
    99

    Remove unwanted text/ numbers from name

    Hi

    I have a very long data list of names that have additional info i dont need as part of the name, I have added a sheet to show the different types of additional info not needed. In column A you have how it is now and in column C is how i need it to read, I still need the original column which ill just hide and show the clean column.

    A formula to resolve

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-13-2014, 12:50 PM #2
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Remove unwanted text/ numbers from name

    Hi,

    =TRIM(LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9,"("},A1&7^18&"("))-1))

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  3. 05-13-2014, 01:47 PM #3
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Remove unwanted text/ numbers from name

    Or 5^19
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  4. 05-13-2014, 02:00 PM #4
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Remove unwanted text/ numbers from name

    Quote Originally Posted by shg View Post
    Or 5^19
    Indeed!
    Reply With QuoteRegister To Reply
  5. 05-13-2014, 02:21 PM #5
    MATU70
    MATU70 is offline
    Registered User
    Join Date
    01-16-2014
    Location
    uk
    MS-Off Ver
    Excel 2013
    Posts
    99

    Re: Remove unwanted text/ numbers from name

    Thank you very much
    Reply With QuoteRegister To Reply
  6. 05-13-2014, 02:31 PM #6
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Remove unwanted text/ numbers from name

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Remove Text+Numbers Sometimes, Based on Other Text in Cell
    By eugeniusjr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-29-2013, 11:37 AM
  2. [SOLVED] [SOLVED] Macro/Wildcard to remove only numbers excluding text with numbers
    By indianhp in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 06-21-2013, 08:16 AM
  3. Macro to change cell format to text and remove unwanted spaces & special characters
    By Chito in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-17-2012, 05:30 AM
  4. Excel 2007 : Remove Unwanted Text from Cells
    By rickygzz in forum Excel General
    Replies: 6
    Last Post: 08-01-2011, 10:28 PM
  5. [SOLVED] Easiest way to remove text from a cell that has text and numbers?
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 08-17-2006, 01:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1