Have you looked at DataText to columns? Use the underscore as the separator

--
Kind regards,

Niek Otten

"Thakku Ramanan" wrote in message
...
Excel should provide an option of merging columns to text.
I face difficulty while tring to sort something of the following form:
VGUIDE_SRD_11350
VGUIDE_SRD_1580_A3XX
VGUIDE_SRD_3504
If a column to text option is provied then I could use the Text to column
option then sort per my requirement then again merge using new column to
text
option if provided.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming