|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 3rd 06, 07:35 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? 
|
| Ads |
|
#2
March 3rd 06, 07:41 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
March 3rd 06, 07:57 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? > >
|
| Thread Tools | |
| Display Modes | |
|
|
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 06:31 PM |
Linear Mode
