Fromatting Imported Data quickly 1

[leewisener]

Hello,

I have some data I am adding to a spreadsheet, Its long and labor intensive as its an old system that I am copying data from and there is no option to run a query or similiar.

So basically its copy rows of data from the old system and paste into Excel. The rows of data look like this>>

BOR 01/01/2002 -305.00

Of course when I paste into Excel it puts all of this into 1 cell.

Is there an easy way to get to make excel realise that in fact I want this in 3 cells rather than one?

Thanks for any help on this one.

Lee

 

[dhulbert]

have you looked at "text to columns" in the Data menu
that will spilt it quickly and easily.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[KenWright]

Data / Text to columns is the way to go, but why are you copying and pasting. Surely you can export the data into a text or csv file, import into Excel and then query it from there.

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[leewisener]

Thanks will try these.

As I said there is no option to export the data, long story!

 

[KenWright]

Ahhh - you mentioned no queries, but not being unable to export the data. Never actually come across a system where that wasn't possible. Oh well, was just a thought.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------