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.