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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.

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" <(E-Mail Removed)> wrote in message news:A96467A3-4AE5-473E-BCD5-(E-Mail Removed)...
> 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.
>>
>>