Thread
:
Pulling a specific email from cells and putting info in new row
View Single Post
#
5
Posted to microsoft.public.excel.misc
Claus Busch
external usenet poster
Posts: 3,872
Pulling a specific email from cells and putting info in new row
Hi Chris,
Am Thu, 7 Mar 2013 11:27:29 -0800 (PST) schrieb
:
XXXXX | Xxxxxxxxx"
Step1
select the column = Data = TextToColumns = Delimited" = Delimiter =
Other = 0 = Column with "Unsubscribe..." skip (do not import column)
Step2
select the column = Data = TextToColumns = Delimited" = Delimiter =
Other = "" = Column with " XXX..." skip (do not import column)
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch