ExcelBanter - How do I break up a concatenated text string ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I break up a concatenated text string ? (https://www.excelbanter.com/excel-discussion-misc-queries/75038-how-do-i-break-up-concatenated-text-string.html)

Bhobhojani Gudo

How do I break up a concatenated text string ?

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 ?

Chris Marlow

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 ?

Bhobhojani Gudo

How do I break up a concatenated text string ?

Chris,
Thank you very much!!!

"Chris Marlow" wrote:

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 ?

All times are GMT +1. The time now is 10:05 PM.