software

0 -177542.58
The above concatenated text string is a dump from another application and I
would lke to extract only -177542.58 How do I go about it ?Hi,

'Data', 'Text To Columns', Accept 'Delimited', hit 'Next' amp; choose 'Space' amp;
that should do the trick.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Masterquot;Bhobhojani Gudoquot; wrote:

gt; 0 -177542.58
gt; The above concatenated text string is a dump from another application and I
gt; would lke to extract only -177542.58 How do I go about it ?
gt;

Chris,
Thank you very much!!!

quot;Chris Marlowquot; wrote:

gt; Hi,
gt;
gt; 'Data', 'Text To Columns', Accept 'Delimited', hit 'Next' amp; choose 'Space' amp;
gt; that should do the trick.
gt;
gt; Regards,
gt;
gt; Chris.
gt;
gt; --
gt; Chris Marlow
gt; MCSD.NET, Microsoft Office XP Master
gt;
gt;
gt; quot;Bhobhojani Gudoquot; wrote:
gt;
gt; gt; 0 -177542.58
gt; gt; The above concatenated text string is a dump from another application and I
gt; gt; would lke to extract only -177542.58 How do I go about it ?
gt; gt;