+ Reply to Thread
Results 1 to 12 of 12

How to split text & numbers in one cell to multiple cells

Hybrid View

  1. #1
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,185

    Re: How to split text & numbers in one cell to multiple cells

    Quote Originally Posted by udprocks View Post
    or just simly use "Text to column" for ur given example

    Text to column-----------fixed width
    It doesn't work because the columns are not of fixed width!
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  2. #2
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2013
    Posts
    365

    Re: How to split text & numbers in one cell to multiple cells

    Quote Originally Posted by AliGW View Post
    It doesn't work because the columns are not of fixed width!
    yes, ali but that was for that first given example file.
    If answer helped you say Thanks by Add Reputation

  3. #3
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2013
    Posts
    365

    Re: How to split text & numbers in one cell to multiple cells

    Quote Originally Posted by AliGW View Post
    It doesn't work because the columns are not of fixed width!
    yes, ali but that was for that first given example file sorry.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,185

    Re: How to split text & numbers in one cell to multiple cells

    Quote Originally Posted by udprocks View Post
    yes, ali but that was for that first given example file sorry.
    Yes, and it didn't work with that file, either!!! What would need to be in the second column were of different lengths.

+ 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: 07-21-2014, 10:33 AM
  2. [SOLVED] Split cell containing numbers and text
    By MATU70 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-23-2014, 04:12 AM
  3. [SOLVED] Delete text, split numbers to two cells and store as numbers
    By Steve_123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2014, 09:51 AM
  4. [SOLVED] Unable to split text and numbers into Separate Cells that have no space
    By BDavis in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-21-2013, 04:39 PM
  5. Split text and numbers into different cells
    By frutz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-15-2009, 09:20 PM
  6. split numbers from text in cell
    By nicko54 in forum Excel General
    Replies: 4
    Last Post: 03-26-2009, 07:24 AM
  7. split text in one cell into multiple cells without breaking the wo
    By Prashant in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2006, 04:48 AM

Tags for this Thread

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