Sorting imported .txt data in Excel

[clickmule]

I have to sort a text string that contains data with * separating eac
item ie:

399*60.15*28.95*NAME*Rogers,Fred*101805

There are over 300 of these names in one string. I want to sort eac
name as a row with the data following. I need this to be don
automatically because the data is time sensitive.

Thanks in advance
:

 

[Guest]

Do you mean 300 strings each with the format like...
399*60.15*28.95*NAME*Rogers,Fred*101805
ie: 300 lines such as: number * number * number * the word "NAME" * a name
* number
???
or 1 line with 300 pieces of data...
399*60.15*28.95*NAME*Rogers,Fred*101805399*60.15*28.95*NAME*Rogers,Fred*101805399*60.15*28.95*NAME*Rogers,Fred*101805399*60.15*28.95*NAME*Rogers,Fred*101805
???

The first can be done with a formula, the 2nd probably needs a macro.

 

[clickmule]

The .txt string contains over 300 names with additional data. What
would a suitable macro look like. What would it do. I don't want
someone to write a free macro but I would like your input.

Thanks
Karl

 

[Guest]

clickmule,
Send me the string in an email to "gary_brown@ge_NOSPAM.com" without the
_NOSPAM part and I'll give you a hand.
Gary