dissimilation of data from a column to multiple column

[quillmaster]

Hi,
I apologize for the vague subject as i was unsure about what to do, i have lots and lots of data in single column, which is as follow
Menu item Name
menu item price
menu description

all three variable are in the single column and one above each other and i have a very long column about 5000 rows, also it is not consistent as well, sometimes there is menu description and sometimes it is not, so we cannot predict the place of a variable in the column as well ( like every fourth entry should be item name, but it is not ), now i want to sort this data into three columns
Menu item name menu item price menu item description

i tried to attach the excel here but didn't work, hence attaching my skydrive link... please check here.

http://sdrv.ms/ZKUfIY

can i anyone help me.....
Mohit

[arlu1201]

How would the macro identify which entry goes where?

[quillmaster]

that's the problem!!!!!! it is a manually copied data from somewhere ( i think ) and now the only thing that i can think is to separate the text from number entries

[quillmaster]

all i need is The sorting of Column C, it contain all the entries and i want to keep the menu item name in Column C the price in Column e and description in column E.

[arlu1201]

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button

[quillmaster]

simply wicked..... you are a real life saver.... you saved my job and hours of work that i had to have spent on this.... people like you are have made this place a real treat to come..... oh and and did i mention you are a real darling......

Mohit

[quillmaster]

though i am not sure how much help i could be .... but if you ever need anything don't hesitate to contact me.....

[arlu1201]

Am glad it worked.

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

[quillmaster]

i have already added your reputation even before you mentioned that in your post.... also i was testing the formula against various data samples.. and that's why i have not marked it solved ... as i may need some adjustment in this based on various scenarios and each time i don't want to open new thread for the same problem and if i marked it solved and then change it to unsolved if would be bad for this forum's reputation....

Mohit