+ Reply to Thread
Results 1 to 3 of 3

Selecting a part of text from 1 column and put this in a new column

  1. #1
    Registered User
    Join Date
    10-22-2013
    Location
    Utrecht, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    29

    Question Selecting a part of text from 1 column and put this in a new column

    I need to put a part of a text from a column and place it in a new collumn. At this moment I use 2 columns and an extra sheet to solve this.

    I have a collumn with a lot of data like:
    aaa-bc
    bbb
    abc-ba-bd
    aa-bb
    bbb-xx-yy
    aa
    abc-yy
    klmn-zz
    klmn-yy-ff
    What I need is behind every cell a new cell with only the 1st part like:
    aaa
    bbb
    abc
    aa
    bbb
    aa
    abc
    klmn
    klmn
    What I do now is use a new column with this formula:
    Please Login or Register  to view this content.
    And I made a translation table in which the 1st 4 characters are translated to what I want to see. In a 3d column I use
    Please Login or Register  to view this content.
    to get the results I need.
    Since I need to get results like this very often this method is very time consuming.

    Is there a formula available I can use with only 1 new column?
    Last edited by Armand0; 10-22-2013 at 10:31 AM.
    Cheers, Armand0

  2. #2
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Selecting a part of text from 1 column and put this in a new column

    Please try this function

    =IFERROR(SUBSTITUTE(LEFT(A1,FIND("-",A1)),"-",""),A1)
    Please click 'Add reputation', if my answer helped you.

  3. #3
    Registered User
    Join Date
    10-22-2013
    Location
    Utrecht, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    29

    Exclamation Re: Selecting a part of text from 1 column and put this in a new column

    Works as needed! Thanks al lot!

+ 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. Replies: 4
    Last Post: 12-20-2012, 04:33 AM
  2. [SOLVED] Selecting Column & Row contain text
    By Priscilla in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-25-2006, 12:25 PM
  3. [SOLVED] Selecting part of a column
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-16-2005, 06:25 PM
  4. Find part of text in column or array
    By Pasmatos in forum Excel General
    Replies: 0
    Last Post: 11-08-2005, 06:40 AM
  5. Count the text in a column - Part II
    By Peter Curtis in forum Excel General
    Replies: 3
    Last Post: 01-06-2005, 03:06 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