How do I break up a concatenated text string ?

  • Thread starter Bhobhojani Gudo
  • Start date
B

Bhobhojani Gudo

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 ?
 
C

Chris Marlow

Hi,

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

Regards,

Chris.
 
B

Bhobhojani Gudo

Chris,
Thank you very much!!!

Chris Marlow said:
Hi,

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

Regards,

Chris.
Click to expand...
 
Top