Thanks, but how and where do I write these formulas?

"Ron Rosenfeld" wrote:

On Fri, 20 Feb 2009 16:35:01 -0800, da wrote:

Hi
Is there any way I can break up the following in three different columns?
Date, Merchant and Amount? At presnt, all info is in one column.
Thanks


01/01/08 ALBERTSONS #6555 UPLAND, CA $3.23
01/01/08 VONS FUEL 10026813 UPLAND, CA $35.50
01/01/08 WAL-MART #1992 UPLAND, CA $17.80
01/02/08 GRAZIANOS ITALIAN RESTAUR UPLAND, CA $12.00
01/02/08 GRAZIANOS ITALIAN RESTAUR UPLAND, CA $7.50
01/02/08 SHELL OIL 57442712808 UPLAND, CA $31.50
01/03/08 MIMIS CAFE 00000125 UPLAND, CA $14.73
01/27/08 UPLAND FARMERS MARKET UPLAND, CA $19.09
01/27/08 VONS Store00026815 UPLAND, CA $24.70
01/28/08 ALBERTSONS #6555 UPLAND, CA $20.50
01/28/08 VONS FUEL 10026813 UPLAND, CA $39.50
01/29/08 NEW BOMBAY STORES UPLAND, CA $27.35


If the only "$" is the one preceding the amount, then

Date:
=LEFT(A1,8)

Merchant:
=MID(A1,10,FIND("$",A1)-11)

Amount
=MID(A1,FIND("$",A1),99)
--ron