Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete text from the beginning and end of cell contents

Status
Not open for further replies.
vsimpkins

vsimpkins

Technical User
Jan 20, 2005
18
US
Hi,
I received an Excel 2003 with multiple rows and data in a single cell. Each cell row contents as follows:
4835 gnordine@pathwaysgroup.net external_affairs
4570 tvaughn1@Amialhost.tes.tulone.edu NMA News
467 jabberwh@aol.com NMA News JNMA List
90 edbeltonmd@aol.com NMA News JNMA List

All I need is the email from each cell. Can you assist with a macro or formula that can be used here?

Valerie Simpkins
 
Sort by date Sort by votes
Did you try using the "text to columns" function? That would let you set spaces as delimiters.

--
JP
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
330
ladyck3
ladyck3
grnzbra
  • Locked
  • Question
Set Cell Equal to Selected Value from Dropdown.
Replies
2
Views
241
combo
combo
Cpreston
  • Locked
  • Question
If cell is blank use data from another cell 1
Replies
10
Views
289
Andrzejek
Andrzejek
TrekBiker
  • Question
Use 2 columns in Detail Section of report 1
Replies
8
Views
480
TrekBiker
TrekBiker
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
393
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top