+ Reply to Thread
Results 1 to 7 of 7

Excel formula textsplit function

  1. 01-09-2024, 11:45 AM #1
    anavarathan
    anavarathan is offline
    Registered User
    Join Date
    02-08-2014
    Location
    Chennai
    MS-Off Ver
    Excel office 365
    Posts
    41

    Cool Excel formula textsplit function

    Dear all,

    I am trying to convert the table1 data into table3 using textsplit function. but the result is not expected. Textsplit output is shown in the table2 that's not the expected result.
    Kindly help me to get the expected result.

    Formula i tried is showing only the 1st line of the cell.
    Please Login or Register  to view this content.
    table convert.png
    Thanks in advance for your kind support.

    Regards
    Anavarathan S
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-09-2024, 11:56 AM #2
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,014

    Re: Excel formula textsplit function

    Try this,
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 01-10-2024, 04:17 AM #3
    anavarathan
    anavarathan is offline
    Registered User
    Join Date
    02-08-2014
    Location
    Chennai
    MS-Off Ver
    Excel office 365
    Posts
    41

    Re: Excel formula textsplit function

    Thank you its working
    Last edited by AliGW; 01-10-2024 at 04:24 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
    Reply With QuoteRegister To Reply
  4. 01-10-2024, 04:30 AM #4
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,014

    Re: Excel formula textsplit function

    You are welcome.
    -----------------------------------
    If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  5. 01-10-2024, 04:36 AM #5
    anavarathan
    anavarathan is offline
    Registered User
    Join Date
    02-08-2014
    Location
    Chennai
    MS-Off Ver
    Excel office 365
    Posts
    41

    Re: Excel formula textsplit function

    Hello, could you please send me the formula that calculates the number of rows and outputs the result? rather than three rows.

    EDIT: plz ignore
    Last edited by AliGW; 01-10-2024 at 04:56 AM. Reason: Post restored - do not delete content!!!
    Reply With QuoteRegister To Reply
  6. 01-10-2024, 04:37 AM #6
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,937

    Re: Excel formula textsplit function

    Another option with Power Query

    Please Login or Register  to view this content.
    Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

    It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

    - Follow this link to learn how to install Power Query in Excel 2010 / 2013.

    - Follow this link for an introduction to Power Query functionality.

    - Follow this link for a video which demonstrates how to use Power Query code provided.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  7. 01-10-2024, 04:45 AM #7
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,014

    Re: Excel formula textsplit function

    Please, upload a sample file with your expected results.
    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. [SOLVED] Excel formula to textsplit from filter function output.
    By anavarathan in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-06-2024, 03:34 PM
  2. [SOLVED] Textsplit doesn't work with Array Formula?
    By FT00 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2023, 01:43 PM
  3. [SOLVED] TEXTSPLIT Function: Is It possible to spill an empty cell with zero?
    By JN831 in forum Excel Formulas & Functions
    Replies: 79
    Last Post: 08-18-2023, 04:45 AM
  4. [SOLVED] Unable to Vlookup with Textsplit function
    By rakul_rakul in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-27-2023, 11:16 AM
  5. [SOLVED] Textsplit/Take/Sequence
    By JEC. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2023, 02:32 PM
  6. [SOLVED] textsplit function not found
    By pedersenn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2022, 11:01 PM
  7. No textsplit on my mac and windows
    By iwanttoexcelinexcel in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-03-2022, 11:29 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1