• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sort Random data of text and numbers

Y

younas

New Member
Hi,

I want to sort random data into text and numbers. I have over 25000 rows of this type of data. I have attached the sample sheet for better understanding. Please note that I have shown the sample input raw data that i have and output data that I want to get from input data.
Please share a way to sort this data by using a formula or macro.

Thanks in advance for your kind support.

Younas
 

Attachments

  • Sample sheet.xlsx
    9.8 KB · Views: 15
Hi Younas ,

See this file.

I have defined a few named ranges , and used 2 helper columns.

If you can do the same in your working file , please do that before you run the macro.

Narayan
 

Attachments

  • Sample sheet.xlsm
    16.2 KB · Views: 5
Hi Narayan,

Thank you so much for the help. I did the changes in my original file and it is working like magic.

Thanks again for your kind support.

younas
 
You must log in or register to reply here.
Back
Top