Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Kiral Demir   on Mar 09 In MS Office Category.

  
Question Answered By: Ulfah Hashmi   on Mar 09

If the addresses  don't contain any spaces, I'd replace  SMTP with space SMTP and
.rib with .rib space, then use "text to columns" in the Data Menu to split up
the text into the bits you do and don't want. (If you have spaces you'll need to
find a character that doesn't appear in the strings of text.)You'll need to
insert a couple of columns to receive the split text, but they can be deleted
once you have the information you want.

Share: 

 

This Question has 12 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Need help with code to find data within a cell Or get search suggestion and latest updates.


Tagged: