Could someone please tell me how to get rid of <null at each page
break. This happens after data is imported to make a report.


--
smorriss25000
------------------------------------------------------------------------
smorriss25000's Profile: http://www.excelforum.com/member.php...o&userid=33233
View this thread: http://www.excelforum.com/showthread...hreadid=530526

Hi "smorriss25000",

Try making a copy of your worksheet, selecting all cells on the
sheet and then running the TrimALL macro found at
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

To make a copy of your worksheet use
Edit, Move or Copy Sheet ..., checkmark the Create a Copy Option, OK
play with a copy of your worksheet, until you know how things work.

If not familiar with creation and use of macros see
http://www.mvps.org/dmcritchie/excel....htm#havemacro

The macro will remove char(160) and trim cells, forcing a reentry
of all cells that appear as text. If that does not solve your problem
you will have to be a lot more specific about describing your problem.
This makes 4 out 4 questions from people submitting to newsgroups
from outside of newsgroups that don't describe the problem, what
you have to begin with, what you get, and what you expected to get.
The use of Null frequently means an empty string in Excel.

Look at the supporting material with the TrimALL macro to see
what =LEN(A44) and =CODE(Right(A44,1) produces for a questionable
cell.

If you want to help yourself and others, I would suggest learning to use
the newsgroups properly, clearly use your name and above all not
to submit questions to newsgroups using ExcelForum.
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/posting.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"smorriss25000" wrote in message
news:smorriss25000.25un0b_1144337704.9381@excelfor um-nospam.com...

Could someone please tell me how to get rid of <null at each page
break. This happens after data is imported to make a report.


--
smorriss25000
------------------------------------------------------------------------
smorriss25000's Profile: http://www.excelforum.com/member.php...o&userid=33233
View this thread: http://www.excelforum.com/showthread...hreadid=530526