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
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. |
All times are GMT +1. The time now is 08:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com