reformatting after importing a text file

[gbpg]

I have a database that has information that can only output all of the
information in it by using a select all and save as text file (its a long
story why the information can't all be exported).

As a result users have to save as the text file and then try and get
information from all of this. when the text is pasted into the Excel file,
the all of the information that would have been been in several fields are
seperated into different cells in the same column.
the field of the database would have a unique identifier - a four digit
number let us say 2345 and so on. This would be followed by text that is
seperated in different cells in one column until the next four digit number
say 2346

Is there a quick way to import the text file into excel and have the text
inbetween the four digit numbers get formatted together into a single cell of
text?

 

[Bob Bridges]

If you want a quick way, try posting this on the Worksheet Functions forum
and they may ask a few questions and tell you something you can do. But here
in the Programming forum we'll all tell you how to do it in a VBA macro,
which (unless you already are running one for the import) won't be quick. It
will work pretty well, though.

Depending on how long the data is, the Worksheet Functions solution may
actually work quicker for you, as well as taking less time to set up.

 

[Greg Glynn]

What sort of database is it? There might be a better way.