assuming that the date will always be only 5 characters but also assuming that the price will not always be three digits before the decimal point, I think you'll need a different logic for the price column.

So, for the date

=LEFT(A1,5)

For the price (assuming that there will always be a decimal point, like 0.99, get the string starting after the first blank and up to two characters after the first dot.

=MID(A1,FIND(" ",A1)+1,FIND(".",A1)-FIND(" ",A1)+2)+0

For the description: get the string that starts 4 characters after the first dot

=MID(A1,FIND(".",A1)+4,9999)

Note that depending on your regional settings you may need to replace the comma with a semicolon.

Really strange. I'm sending an Excel to you. I use Excel in spanish so my names on the formulas are not the same, maybe there is a little difference with the translation I made. Please see if the Excel attached is working on your side.make-3-columns-date-price-descri.xlsx

Featured Post

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

A2 = A1
That kind of cell reference is relative. If you copy it from A2 to B2, then B2 will get this:
B2 = B1
That's all fine and good, but if you then insert a new row above row 2, you'll find:
A3 = A1
B3 = B1
This is intentional. …

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code)
David miller (dlmille)
Intro
Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…

This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.