View Single Post
  #2   Report Post  
Old March 3rd 06, 08:41 AM posted to microsoft.public.excel.misc
Chris Marlow
 
Posts: n/a
Default How do I break up a concatenated text string ?

Hi,

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

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"Bhobhojani Gudo" wrote:

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 ?