+ Reply to Thread
Results 1 to 8 of 8

arrange text and numbers separately in a single cell

  1. #1
    Registered User
    Join Date
    08-25-2015
    Location
    Kolkata, India
    MS-Off Ver
    2013
    Posts
    59

    arrange text and numbers separately in a single cell

    I have some mixed kind of data likewise " text 1234 text 4567 text 7654" and I want the the numbers arranged either on the left side or side of the cell. How can I do that?
    Last edited by nadimqaisar; 08-25-2015 at 10:35 AM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: arrange text and numbers separately in a single cell

    So you want "123445677654 texttexttext"?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    08-25-2015
    Location
    Kolkata, India
    MS-Off Ver
    2013
    Posts
    59
    1234 4576 7654 text text text..... like this

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: arrange text and numbers separately in a single cell

    Any sort of patterns?
    Always 3 sets of numbers and text?
    Always sets of 4 digits? If not, what range?
    Always "# space text space # space text space number space text"?
    Any specific number of or range of characters in the text?

  5. #5
    Registered User
    Join Date
    08-25-2015
    Location
    Kolkata, India
    MS-Off Ver
    2013
    Posts
    59
    This is the issue that there is no set pattern. Numbers can appeat multiple times, text can appear multiple times. No set pattern. Text can appear any where, number can appear any where. Range is also not fixed. The same or different combination can appear in multiple cells.
    Last edited by nadimqaisar; 08-25-2015 at 12:04 PM.

  6. #6
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: arrange text and numbers separately in a single cell

    Are you opposed to a UDF (User Defined Function requireing VBA)

  7. #7
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: arrange text and numbers separately in a single cell

    Here is a spreadsheet with a UDF. The name of the UDF is NumsFirst so would use it just lke a normal function =NumsFirst(A1)

    The code is
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by ChemistB; 08-25-2015 at 01:40 PM.

  8. #8
    Registered User
    Join Date
    08-25-2015
    Location
    Kolkata, India
    MS-Off Ver
    2013
    Posts
    59
    Thank you so much sir for your generous support. Will test this once I reach office and let you know.

+ 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] Alphabetically arrange content in a single cell
    By SASIURFREND in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2014, 12:18 PM
  2. [SOLVED] Need to extract text from within multiple strings and arrange it in a single column
    By sampflederer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2013, 01:35 PM
  3. Replies: 2
    Last Post: 02-23-2013, 06:54 AM
  4. Split numbers and text from a single Cell
    By wong_lizzie in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-17-2012, 08:12 AM
  5. Replies: 5
    Last Post: 01-17-2012, 12:50 PM
  6. Replies: 2
    Last Post: 08-16-2011, 09:03 AM
  7. Cell Value vs Displayed Text... how do I set them separately?
    By nickwee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2007, 03:02 AM
  8. Sorting numbers and text separately
    By Tim C in forum Excel General
    Replies: 8
    Last Post: 07-20-2005, 08:05 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