Joe,

When you import data (especially from another program or platform), there
will be times when you'll encounter data validation and formatting errors.
You can create macros which will clean-up/scrub your data during the import
process. You can take the steps that Steve gave you, and create a macro.

HTHs


"Joe" wrote in message
...
OK. Thanx, Steve. That worked - finally!
I had to "TRIM" all of the columns I was working in to get this to work.
Do you know what is causing it to fail like that, and what can I do in the
future to avoid having this problem again (I am bringing in data from an
AS400 system to create my reports and analysis)? Am I importing the
information incorrectly? Whatever you can suggest will be greatly
appreciated.
Thanx, again.

Joe

"SteveG" wrote:


Joe,

Go to the tab June 2006 in the Current Rankings workbook. Insert an
entire column between columns H and I (this is only temporary). Do
this by clicking on the column header of column I. Right mouse click
and select insert. This will make the I column of data shift to J
leaving I blank. In I1 type in
=TRIM(H1). Copy this down to the end of your data in column H.

Highlight the entire column I where you used the TRIM function (you can
do this by clicking on the column header) and copy it. Then select
column H by clicking on the column header. Right mouse click on the
highlighted column H and select Paste Special from the options. When
the dialog box comes up, select "Values" from the list of Paste
options. Click OK. You can then delete column I which will shift the
data back to it's original layout. This replaces your old data list
with an identical list but removing any trailing spaces.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=568361