Boxes in my addresses
 

Hi

i am inserting an address from outlook into excel by selecting the
chossen address through a combobox.

The address is all in one cell and has a box after each line.

How do i get rid of the boxes?

Thanks for any help in advance.

Boxes in my addresses
 

"Oggy" wrote in message
ups.com...
Hi

i am inserting an address from outlook into excel by selecting the
chossen address through a combobox.

The address is all in one cell and has a box after each line.

How do i get rid of the boxes?

Thanks for any help in advance.



this is really an Excel question not Outlook. Select the box, copy, and do a
find and replace, replacing the box with nothing.

Boxes in my addresses
 

When the strings are concatenated into an Excel Cell using vbcrlf then the
strings do go into different lines but there appears a box at the end of the
lines. Use vblf instead.

Experiment by using the Immediate window to do the following

Cells(1,1).value = "a" & vbcrlf & "b"
Cells(1,1).value = "a" & vblf & "b"

This might be the issue when you are moving the data into Excel.

Alok

"Oggy" wrote:

Hi

i am inserting an address from outlook into excel by selecting the
chossen address through a combobox.

The address is all in one cell and has a box after each line.

How do i get rid of the boxes?

Thanks for any help in advance.

Boxes in my addresses
 

Also see Eric Legault's handy tip for an Excel formula to break up the lines -- http://blogs.officezealot.com/legaul...4/08/4502.aspx

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Alok" wrote in message ...
When the strings are concatenated into an Excel Cell using vbcrlf then the
strings do go into different lines but there appears a box at the end of the
lines. Use vblf instead.

Experiment by using the Immediate window to do the following

Cells(1,1).value = "a" & vbcrlf & "b"
Cells(1,1).value = "a" & vblf & "b"

This might be the issue when you are moving the data into Excel.

Alok

"Oggy" wrote:

Hi

i am inserting an address from outlook into excel by selecting the
chossen address through a combobox.

The address is all in one cell and has a box after each line.

How do i get rid of the boxes?

Thanks for any help in advance.