As long as there are no other blank cells you don't mind getting rid of...
- Highlight the selected cells in question
- Hit 'Control+H'
- Enter one space (ie. hit the space bar once) in the 'Find What' section
- Don't enter anything in the 'Replace With' section
This should eliminate all the spaces.
"PokerZan" wrote:
I have a list of names with email addresses of attendees of a seminar
series that I am trying to compile into a list that can be copied and
pasted into an email (using BCC as the methodology for emailing).
The challenge that I have is that when these files were exported from
the database to excel (not sure how), all of the cells contain exactly
100 characters even though the email address may only contain 13-20
characters. Is there a way to "trim" the blank characters after the
last character that is used by a letter instead of blank character
field?
Thanks in advance!
PZan
--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=376384