make-3-columns-date-price-description

put on B1 cell this formula:
=LEFT(A1;5)

put on C1 cell this formula:
=MID(A1;7;6)

put on D1 cell this formula:
=MID(A1;14;9999)

Then select cells B1 to D1 and expand them to last row you have data.

Regards.

error when I type in formula in b1

Hello,

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.

cheers, teylyn

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

=LEFT(A1,5)

works in the first row

I have many rows

I remember in a previous excel I could see an input bar above row1

looks like a browser url input bar

gplana
looks nice

how can I see the formulas and apply the formulas after I add more rows.

Thanks for teaching me to expand the area.