Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 3rd 06, 08:35 AM posted to microsoft.public.excel.misc
Bhobhojani Gudo
 
Posts: n/a
Default 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 ?


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

  #3   Report Post  
Old March 3rd 06, 08:57 AM posted to microsoft.public.excel.misc
Bhobhojani Gudo
 
Posts: n/a
Default 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 ?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I convert text string into a cell reference Dave Davis Excel Discussion (Misc queries) 3 June 10th 08 09:38 PM
How do I look up a number within a string of text Rich Hayes Excel Worksheet Functions 3 October 14th 05 05:49 PM
How to import a text file to Excel treating all input content are in string. Chittu Excel Discussion (Misc queries) 1 July 22nd 05 06:37 AM
Extracting from a text string AmyTaylor Excel Worksheet Functions 3 June 24th 05 01:34 PM
Formating a text string? METCO1 Excel Discussion (Misc queries) 2 November 30th 04 07:31 PM


All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017