EXCEL REPORT SAVED FROM ACCESS

  • Thread starter Thread starter JUANITA
  • Start date Start date
J

JUANITA

I HAVE A REPORT SAVED FROM AN ACCESS DATA BASE THAT I
WOULD LIKE TO MANIPULATE, HOWEVER THE INFORMATION IN THE
DIFFERENT COLUMNS ALL RUN TOGETHER IN ONE LONG CELL WITH
SPACES IN BETWEEN.

IS THERE A FIX FOR THIS W/OUT IT BEING EXTREMELY TIME
CONSUMING, ie DELETING ALL THE SPACE ETC.

THE DATA BASE (PURCHASED) DOES NOT ALLOW EXPORTING.
 
Juanita,

1) Use DATA / Text to columns from the menu (works more or less the same way
as importing a text file with the wizard) or
2) Have a look at the function Split

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
YOU'VE LOST ME COMPLETELY.
-----Original Message-----
Juanita,

1) Use DATA / Text to columns from the menu (works more or less the same way
as importing a text file with the wizard) or
2) Have a look at the function Split

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *




.
Click to expand...
 
Can you please stop using all caps, it is considered shouting...
I don't know how to explain it other that what Auk did, You click
data, text to columns, then use space as delimiter will split the data
at every space..
 
Thanks Peo,

In addition to that Juanita, first select the cell or column with your data
and then follow Peo's instructions.

Since you have obviously never done this before it's probably wise to test
first on a copy of your (imported) datarange to avoid having it to create it
again.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top