The spaces should be spaces and be recognised as such. However you might
find that the problem is what Excel is using to understand where one
number starts and another ends. In most import formats, this is handled
by a tab character (small right pointing arrow only visible in MS Word
when you enable the Printers symbol).
Q: Is the stockbroker's detail imported as an ASCII file or are you
trying to copy a spreadsheet directly into Excel? I would suggest you
try an interim step (I have a similar problem and still haven't found
the seamless answer yet): Copy the Stockbrocker statement and paste it
into WORD first. Your should end up with something like this:
-$154,000.45 $145.541$15,098.98 etc (the is actually a right
facing arrow which I can't reproduce here). Note that the second column
contains a blank space which Wrod understands as a space or null.
If you then copy with from Word into Excel, I think you will end up
with numbers and blanks in the right places...

Cheers
Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=565238