+ Reply to Thread
Results 1 to 4 of 4

Need formula split the clumpse report as 3 layer

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Need formula split the clumpse report as 3 layer

    Dear experts

    I have downloaded bankstatement , have trouble to segregation as proper description , need excel experts inputs to solve this issue

    the rawdata contains description start with long text then have long space then dates(inproper format) then text values
    i want split text date then text

    find the image below you got what i need

    thanks
    Attached Images Attached Images
    Last edited by breadwinner; 06-24-2022 at 08:16 PM. Reason: proper inputs

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,150

    Re: Need formula split the clumpse report as 3 layer

    Please see yellow banner on how to attach a sample wotkbook as respondents are not going to spend time typing in sample data.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need formula split the clumpse report as 3 layer

    Hi sheet added for reference
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: Need formula split the clumpse report as 3 layer

    The following seems to work for the sample provided.
    For Split 1: =IF(D2="",A2,LEFT(A2,SEARCH("/",SUBSTITUTE(A2," ","/",2))-1))
    For Split 2: =IFERROR(LEFT(MID(A2,MIN(SEARCH({0,1,2,3},A2&"0123")),99),SEARCH(" ",MID(A2,MIN(SEARCH({0,1,2,3},A2&"0123")),99))-1),"")
    For Split 3: =IF(D2="","",RIGHT(A2,LEN(A2)-SEARCH(D2,A2)-LEN(D2)))
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Multiple layer COUNTIF AND/OR formula
    By edgg4291 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-08-2019, 07:31 PM
  2. Macro for Split Report
    By dtallent in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-19-2018, 10:38 AM
  3. Split single report into several customized report
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2017, 11:56 PM
  4. Adding an extra layer to this array formula
    By liquidmettle in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-04-2015, 04:46 PM
  5. [SOLVED] Split productivity report into two lines of business
    By Detritus Of Sparta in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-15-2015, 11:32 AM
  6. VB Script - Split Report PDF into mutiple files
    By rmikulas in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2012, 10:53 AM
  7. Multi-Layer Product-IF Formula
    By Sleeper in forum Excel General
    Replies: 0
    Last Post: 05-16-2011, 05:12 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1