Split text , uniformly paste in rows and columns.

[nshanmugaraj]

HI

I have the text in the notepad imported from a file.

DATE FINAL DATE NAME AMT1 AMT2 VALUE

3/31/2003 6/02/2003 THOMAS 4.950 15.00 693.00
3/31/2003 6/02/2003 HARI 7.220 15.00 693.00
3/31/2003 6/02/2003 THOMAS 4.950 15.00 693.00

and so on...

Now from the notepad , i had pasted in the excel column A.
this shows the record in column A.

how can i write a macro to paste the fields each on a column.

PLEASE HEL

 

[Tom Ogilvy]

You don't need to. Just do Data=>Text to Columns and walk through the
wizard.

An alternative would be to just open the file by using file=>Open which
should walk you through the same wizard as above.
--
Regards,
Tom Ogilvy


"nshanmugaraj" <[email protected]>
wrote in message
news:[email protected]...

 

[nshanmugaraj]

dear Tom Ogilvy,
Thanks for the reply.

but .. I need to open the notepad and do the split by writng a
macro..
PLS REPL