Deleting Blank Characters in a Cell
 

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

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

WOW, thanks a ton! That worked like a charm!


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=376384

You realize that will remove spaces between names etc as well?

http://www.mvps.org/dmcritchie/excel/join.htm#trimall


Regards,

Peo Sjoblom

"Corey" wrote:

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

Yes I do, however these are email addresses only in the field so there
aren't spaces as email addresses cannot contain spaces.

Thanks for the heads up though.

PZan


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=376384