+ Reply to Thread
Results 1 to 5 of 5

Need to split info in a cell

  1. 05-30-2023, 06:02 PM #1
    JakeCook1244
    JakeCook1244 is offline
    Registered User
    Join Date
    01-19-2023
    Location
    USA
    MS-Off Ver
    Most recent
    Posts
    7

    Need to split info in a cell

    Hey all,

    please see the attached file ExampleFile5-30.csv

    I would like to separate the First name & phone numbers into 2 different columns. Is it possible to split this info? (I have ablebits as well if that changes anything)
    Reply With QuoteRegister To Reply
  2. 05-30-2023, 06:07 PM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Need to split info in a cell

    Administrative Note:

    Is your forum profile showing the version of Excel that you need this to work for? This is important and 'most recent' is not specific enough

    Members will tailor the solutions they offer to the version of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

    The three most recent versions of Excel are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the release number in your profile (e.g. MS365 Version 2211). This is in the About Excel section further down the Account page.

    Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 05-30-2023, 06:09 PM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Need to split info in a cell

    Data ribbon - Text to Columns - use the semi-colon as the delimiter.
    Reply With QuoteRegister To Reply
  4. 05-30-2023, 06:12 PM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Need to split info in a cell

    Thanks for the rep.

    Please update your forum profile as requested and mark this thread as solved.
    Reply With QuoteRegister To Reply
  5. 05-30-2023, 06:18 PM #5
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Need to split info in a cell

    also you can try Power Query

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sandy666; 05-30-2023 at 06:37 PM.
    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. Split cell to create sorted heading on empty row above and keep second split info
    By CastingDirector in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2015, 12:24 AM
  2. Split and delete info in one cell?
    By LuckyMan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2013, 03:48 PM
  3. split info from one cell
    By denfan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-18-2012, 02:19 PM
  4. split info in a cell to different cells.
    By faze in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-18-2008, 03:38 AM
  5. Split out info in a Cell
    By Stuartf in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-22-2006, 05:10 AM
  6. Split info in cell
    By ottok in forum Excel General
    Replies: 1
    Last Post: 07-20-2005, 07:05 AM
  7. [SOLVED] Trying to split up info in one cell to several
    By Cindy in forum Excel General
    Replies: 2
    Last Post: 02-16-2005, 02:02 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