| Home |
| Search |
| Today's Posts |
|
#1
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 ? |
|
#2
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
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
| How do I look up a number within a string of text | Excel Worksheet Functions | |||
| How to import a text file to Excel treating all input content are in string. | Excel Discussion (Misc queries) | |||
| Extracting from a text string | Excel Worksheet Functions | |||
| Formating a text string? | Excel Discussion (Misc queries) | |||
Linear Mode
