Results 1 to 4 of 4

Splitting Multiple Text and Numbers in excel

Threaded View

  1. 01-07-2017, 02:36 PM #1
    formexcel
    formexcel is offline
    Registered User
    Join Date
    01-04-2016
    Location
    uk
    MS-Off Ver
    10
    Posts
    49

    Splitting Multiple Text and Numbers in excel

    Hi

    I was wondering if anyone could help me split the text in the attached excel file.

    It has multiple numbers and text that need splitting up.

    Ideally Id like to use a formula rather than functions or VBA.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Joining Multiple excel sheet (Appending data), splitting text, Macro requied
    By chilli16 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 07-30-2018, 11:22 AM
  2. [SOLVED] Splitting Text and Numbers from the one cell
    By coach.32 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-28-2015, 04:06 PM
  3. [SOLVED] Splitting Inconsistent Text and Numbers With No Delimiters
    By clhockey5779 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 09-03-2014, 05:52 PM
  4. [SOLVED] Splitting numbers and text to their respective columns
    By JEAN1972 in forum Excel General
    Replies: 7
    Last Post: 07-31-2014, 06:48 AM
  5. Any way to import large text file of numbers without Excel splitting numbers?
    By makisupa94 in forum Excel General
    Replies: 19
    Last Post: 07-20-2014, 04:55 PM
  6. Splitting Multiple Numbers in One Cell to Multiple Cells
    By J Morrow in forum Excel General
    Replies: 2
    Last Post: 06-23-2011, 04:24 AM
  7. Splitting a Text File and importing into multiple excel files
    By DhavokD in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2009, 02:44 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