# make-3-columns-date-price-description

using excel 2007 on windows

make-3-columns-date-price-descri.xlsx

I will have many columns so please set a rule

make-3-columns-date-price-description
LVL 1
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
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.
Author Commented:
error when I type in formula in b1
Microsoft MVP ExcelCommented:
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
Commented:
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
Microsoft MVP ExcelCommented:
The error message is because of gplana's regional settings use the ; in a formula and rgb192 has regional settings with a comma as the list separator.
Author Commented:
=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
Author Commented:
gplana
looks nice

how can I see the formulas and apply the formulas after I add more rows.
Commented:
just select the fields with the formula, and then expand the range on new files
The formulas will copy automatically by changing A1 by An (where n is the row where you copy the formula)

Experts Exchange Solution brought to you by