Classifying 5000 stars

Attached is a spreadsheet with data about 10000 stars. You will be concerned with the rightmost 5 columns of the 5000 stars on top. A lot of the information is repetitive and can be done together with ease. Here are your tasks: 1) Separate the information under Remarks(5th from the right) into Multiple Stars, Variable Star, Planet, Phase. The last 4 pieces of information are currently lumped together under Remarks. The Remarks column should only store information about the names and other information that cannot be classified into the 4 categories. The first 100 stars on top have roughly been done for you as a demonstration. 2) Some of the remarks contain annotation numbers such as [2], (c) etc. You need to remove them. 3) You need to make sure each cell does not end with a symbol such as ;. Proper capitalization needs to be ensured too. 4) You also need to split the Variable Star column into 5 columns: Variable Star Remark, Delta V, Min V, Max V, P. You need to fill them in appropriately. Variable stars normally come with such information. Please include the tag [HAPPY UNIVERSE] in your bid to show that you are not a bot.