Hi,

Here is an entirely different approach:

1. Select all the data in the column and choose Data, Text to Columns,
2. Select Fixed width and click Finish. The first column should be your
dates.
3. Select the second column and choose Data, Text to Columns,
4. Select Delimited and click Next.
5. Select Other and enter $ as the delimiter and click Finish.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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