Excel Tab Characters replace and extract e-mail from field :: MrExcel Message Board


 FAQFAQ
   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   FavoritesFavorites   StatisticsStatistics 
 RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Online StoreOnline Store

MrExcel Message Board Forum Index -> Excel Questions

Tab Characters replace and extract e-mail from field
Post new topic   Reply to topic
Last Thread | Next Thread  >   Printable version
  Author    Thread

steven H
Board Regular


Joined: 20 Feb 2002
Posts: 51
Location: Liverpool UK
Flag: Fiji

Status: Offline

 Reply with quote  

I have imported an outlook folder into excel in order to attempt to extract the e-mail addresses from within the subject body of the e-mail (they have been bounced due to the wrong addresses).

I have attempted unsuccessfully (with the help of guys on the board) to extract them.
My problem is is that within the message body (which forms one excel field) is a garbled mess seperated by what i beleive are tab characters(they appear as squares when the field is highlighted) The e-mail addresses have this 'tab' character either side. I beleive with the previous help I have received I can extract the e-mail addresses if i can make these characters into one recognisable by excel however find replace does not work as the character does not appear within the find character set. Unfortunately If i use the clean function the address becomes part of a string of characters with no consistent deliminaters either side. Any ideas? as I am really struggling with this.

Post Tue Jun 25, 2002 5:45 am 
 View user's profile Send private message Visit poster's website

steven H
Board Regular


Joined: 20 Feb 2002
Posts: 51
Location: Liverpool UK
Flag: Fiji

Status: Offline

 Reply with quote  

I have discovered the tab character is alt 10 however using find and replace will not work, get the message that the character cannot be found. Ay ideas

Post Wed Jun 26, 2002 2:08 pm 
 View user's profile Send private message Visit poster's website

PaddyD
MrExcel MVP


Joined: 02 May 2002
Posts: 5681


Status: Offline

 Reply with quote  

I guess this is a continuation of:

http://www.mrexcel.com/board/viewtopic.php?topic=11744&forum=2

Can't quite see the problem - why doesn't text to cols work??

See the worksheet simulation for the example you gave. It uses text to column with the pipe as the delimiter & "treat consectutive delimiters as one' selected.

Microsoft Excel - Book2___Running: xl97 : OS = Windows Windows 2000
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp
=

A
B
C
D
E
F
1
|steven||steve@steve.co.uk||vvv|ddd|
stevensteve@steve.co.ukvvvddd
2






3






4






5






Sheet1

To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

The above image was automatically generated by [HtmlMaker 2.12] If you want this FREE SOFT, click here to download
This code was graciously allowed to be modified: by Ivan F Moala All credit to Colo


so we have the email address separated out - where's the problem??

Paddy

Post Thu Jun 27, 2002 1:30 am 
 View user's profile Send private message

steven H
Board Regular


Joined: 20 Feb 2002
Posts: 51
Location: Liverpool UK
Flag: Fiji

Status: Offline

 Reply with quote  

Paddy you are right this is a continuation from my previous post , i have established i can seperate the field out using text to columns using the tab symbol as the deliminator. I dont know why text to columns wont work as I can only get it to fill in the C2 column as per your example, is there something I have missed?

[ This Message was edited by: steven H on 2002-06-27 02:32 ]

[ This Message was edited by: steven H on 2002-06-27 02:34 ]

Post Thu Jun 27, 2002 6:31 am 
 View user's profile Send private message Visit poster's website

PaddyD
MrExcel MVP


Joined: 02 May 2002
Posts: 5681


Status: Offline

 Reply with quote  

If you're still having a problem, download the html add-in (see link at bottom of screen) & post some of your data.

Paddy

Post Thu Jun 27, 2002 5:52 pm 
 View user's profile Send private message

steven H
Board Regular


Joined: 20 Feb 2002
Posts: 51
Location: Liverpool UK
Flag: Fiji

Status: Offline

 Reply with quote  

Paddy

Thanx for bearing with me!

At work, the download site is off limits will get on line over the weekend and post, its driving me nuts cos it should work as your example.

[ This Message was edited by: steven H on 2002-06-28 00:57 ]

Post Fri Jun 28, 2002 4:55 am 
 View user's profile Send private message Visit poster's website
  Display posts from previous:      

MrExcel Message Board Forum Index -> Excel Questions


Forum Jump:
Jump to:  

Post new topic   Reply to topic
Page 1 of 1



Add To Favorites

 


Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB: 2.0.4 © 2001 phpBB Group

Need help posting your first question? Read how to post

Need extra help ? Couldn't get the answer you needed ? Get a free quote from our Consulting Team

Download Colo's HTML Maker utility for displaying your Excel Worksheet on the board.

Download VB HTML Maker to post your code on the board


Check out our new index to 485 Excel Articles.


Return to MrExcel Consulting

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the Terms of Use
Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.