Closed Thread
Results 1 to 2 of 2

Arranging DATA accordingly/removing unwanted TEXT

  1. 04-15-2024, 11:49 PM #1
    tempertrap
    tempertrap is offline
    Registered User
    Join Date
    05-16-2023
    Location
    Philippines
    MS-Off Ver
    18.2303.1201.0
    Posts
    11

    Question Arranging DATA accordingly/removing unwanted TEXT

    Hi Team,

    I need help on doing an excel file wherein once I paste a certain data in a column, it will then arrange accordingly to the format that I want in another columns

    I've attached here a sample file and the one in YELLOW Cells the result format that I need. Please take note that the number column may change.

    I hope someone can help me with this one. Will very much appreciate your help.

    Thank you in advance.
    Cheers!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-16-2024, 12:19 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Arranging DATA accordingly/removing unwanted TEXT

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #2 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: link to be added here

    Thread closed.

    https://www.excelforum.com/excel-gen...nted-text.html
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
Closed 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. Arranging DATA accordingly/removing unwanted TEXT
    By tempertrap in forum Excel General
    Replies: 3
    Last Post: 04-16-2024, 01:09 AM
  2. Sum of data in different rows into 1 row after removing unwanted text like #ref! and space
    By mukuljain99 in forum Excel General
    Replies: 8
    Last Post: 11-02-2019, 01:31 PM
  3. Removing unwanted data
    By vallyking in forum Excel General
    Replies: 9
    Last Post: 06-03-2015, 10:25 AM
  4. [SOLVED] Removing unwanted data by date
    By gpowell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2013, 06:33 PM
  5. Removing Unwanted Data
    By njexpress9 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2009, 03:41 PM
  6. Removing unwanted text
    By Chris_b_84 in forum Excel General
    Replies: 2
    Last Post: 10-07-2006, 09:40 AM
  7. Removing unwanted space at end of text cell
    By Alastair79 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2006, 10:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1