Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.outlook
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.outlook
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.outlook
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Boxes in my addresses | Excel Discussion (Misc queries) | |||
Data validation boxes, outputting a final number from the boxes | Excel Discussion (Misc queries) | |||
Moving. Want to number boxes and inventory contents of boxes | Charts and Charting in Excel | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) |