Results 1 to 4 of 4

How to arrange the unformatted text in table format

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-08-2020
    Location
    MUMBAI
    MS-Off Ver
    MS Office 2007 (in 2024)
    Posts
    264

    How to arrange the unformatted text in table format

    I have to deal with unformatted text files which contains transactions. I am attaching here sample of this text file in Sheet1 which contains many data which I don’t need. I have manually arranged data of this unformatted text file data in the manner I need in Sheet2. Kindly provide the solution to arrange this data.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 04-13-2020, 09:57 PM
  2. [SOLVED] VB Code to arrange data in Table format
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2019, 04:42 PM
  3. [SOLVED] Arrays incorrect in macro to re arrange data into table style format
    By antonio32 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-29-2017, 03:55 PM
  4. Unformatted Data Into Table Content
    By LesliePrabakar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-19-2016, 11:37 AM
  5. Need Help - Paste Special (Unformatted Text)
    By websters82 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-10-2013, 10:48 AM
  6. Link to Publisher as Unformatted Text
    By agentred in forum Excel General
    Replies: 0
    Last Post: 05-25-2010, 02:09 PM
  7. merge unformatted date with text
    By Art in forum Excel General
    Replies: 2
    Last Post: 03-18-2005, 02:06 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