• 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.

TXT file to xcel without losing formatting

A

ALAMZEB

Member
Hi Guys

I tried using delimited & all i could but i cant successfully convert this into xcel without losing format.

I tried coverting to .txt than to xcel but no use
I tried macro but couldnt get this done
 

Attachments

There are several ways of doing this...either using vba or formulae or other functionalities of excel...however, before we come up with a solution..can you please share the desired output of the attached txt..

Also, how big can your data set be?
 
Hi Asheesh

the desired output would be same as in txt file. i have attached file as example,the only difference to txt is deletion of row if it doesnt have any numbers in it.
the data varies, itccan goes upto 20 rows to 300 rows
 

Attachments

thanks Asheesh, thars perfect

is there any way we can use this as macro so i can use that for more sheets like that instead of putting formula everytime
 
Check if the attached helps...

Always paste the notepad data in cell A1 of "PasteData" tab..and then click on run button on "Run" tab..
 

Attachments

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