+ Reply to Thread
Results 1 to 5 of 5

Need Help to pick out data and place in next column

  1. #1
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    389

    Need Help to pick out data and place in next column

    How can I pull the email address over into next column, I have a file with thousands of entries like the attached, I require the email address to be separate from everything else.


    Dougers1
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,154

    Re: Need Help to pick out data and place in next column

    Power Query solution

    Please Login or Register  to view this content.
    Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

    It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

    - Follow this link to learn how to install Power Query in Excel 2010 / 2013.

    - Follow this link for an introduction to Power Query functionality.

    - Follow this link for a video which demonstrates how to use Power Query code provided.

  3. #3
    Registered User
    Join Date
    11-02-2020
    Location
    Paris, France
    MS-Off Ver
    Professional Plus 2013
    Posts
    41

    Re: Need Help to pick out data and place in next column

    Hi Dougers1,

    You have two ways of doing this.

    1 - Data > transform using your ";" delimiter, then strip "Email1 " from your second column either by search and replace or by formula.
    2 - Using Excel wizardry, see below.
    Attached Files Attached Files
    ⭹ If this helped you, please add reputation

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    5,173

    Re: Need Help to pick out data and place in next column

    Please try at B1:C1

    =TRIM(RIGHT(SUBSTITUTE(TRIM(MID(SUBSTITUTE($A1,";",REPT(" ",99)),COLUMNS($B1:B1)*99-98,99))," ",REPT(" ",99)),99))
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    389

    Re: Need Help to pick out data and place in next column

    Thanks Guys

    this is great saves me a load of time

    D

+ 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] Index & Match to pick out 'all' the data values in a 'specified" column of data
    By david2020 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-11-2020, 06:49 AM
  2. Replies: 2
    Last Post: 07-02-2015, 09:45 AM
  3. [SOLVED] Formula to pick data from a column then a row help :)
    By enagli in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2014, 03:01 PM
  4. Pick diff pick list as per column value
    By ROHAN999 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-10-2013, 12:10 PM
  5. Pick Values from cell and Place replace it to Dynamic field
    By nittin123goel in forum Excel General
    Replies: 3
    Last Post: 08-21-2013, 07:03 AM
  6. [SOLVED] How to pick a value from a array of data corresponding to column and a row
    By chrismonica in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 04:21 PM
  7. Replies: 2
    Last Post: 02-13-2012, 09:03 AM

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