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.

"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.

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.

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.