+ Reply to Thread
Results 1 to 3 of 3

Split column/cell on specific text

  1. #1
    Registered User
    Join Date
    12-13-2016
    Location
    Altoona, PA
    MS-Off Ver
    2016
    Posts
    9

    Split column/cell on specific text

    I need to split cells on a specific text. On the attached work sheet I need column B split before the work "Total". Usually this would be a job for text to columns, however I cannot use the letter "T" or use a space because there are other "T"s and other spaces...... And for some reason I am unable to attach a work book so suggestions would be helpful anyway.
    Thanks

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Split column/cell on specific text

    There is no workbook attached.

    Attach a sample workbook (see how to do this below). Make sure there is just enough data to demonstrate your need.

    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Split column/cell on specific text

    It could be something like this
    Enter formula in B1 and drag formula across to C1
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    v A B C
    1 Text 1 Text 2 Total: 250.00 Text 1 Text 2 Total: 250.00
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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] vba to split numbers and text to their headers from a merge cell column
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-22-2017, 09:40 AM
  2. [SOLVED] Split column before X numbers (as text) in cell
    By JMusch in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2015, 05:15 PM
  3. [SOLVED] Split Cell text New Column
    By laxmanann in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2014, 07:32 AM
  4. Replies: 1
    Last Post: 02-03-2014, 02:13 PM
  5. [SOLVED] IF column = specific text then copy value from another cell along the same column
    By Lifeless in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2013, 04:15 PM
  6. Replies: 19
    Last Post: 04-10-2013, 08:30 AM
  7. Split Excel Cell w/o Text-2-Column?
    By benkmann in forum Excel General
    Replies: 13
    Last Post: 05-12-2008, 06:26 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