Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-17-2010, 06:09 AM
sixhobbits sixhobbits is offline Wildcard Problem with Emailadresses Windows 7 Wildcard Problem with Emailadresses Office 2007
Novice
 
Join Date: Aug 2009
Posts: 6
sixhobbits is on a distinguished road
Default

I find the word find & replace difficult to use. Would you consider using Excel rather?



Paste/ import all email addresses into an excel spreadsheet.

Select the entire column which contains the email addresses.

Go to the 'data' tab in the ribbon and press on 'text to columns'

Leave on 'delimited' option and press next.

Under 'delimiters' choose other and type @ into the box.

press next, leave on 'general' format, and press finished.

Now you should have all the domains separate from the user names.

HTH

Sixhobbts
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Wildcard search help. Kempston Word 0 11-13-2009 03:58 AM
Extract from String using Wildcard whousedmy Word 0 05-21-2009 01:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft