Boxes in my text - ExcelBanter

Posted to microsoft.public.excel.programming

Adam[_18_] Adam[_18_] is offline

external usenet poster

Posts: 10

Boxes in my text

Hi

I have imported an address from outlook and pasted it into on cell in
excel. The line of text includes the carriage return boxes.

How can change my code to replace the boxes for a space.

ActiveCell.Offset(0, 1).Select
Selection = .BusinessAddress

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Default font for pasted text in text boxes - Excel 2007	MS OFFICE USER EIT	Excel Discussion (Misc queries)	0	March 25th 10 09:01 PM
User Form Text Boxes - Copy format of text boxes	NDBC	Excel Discussion (Misc queries)	3	July 2nd 09 02:02 AM
How to Import Visio Text Boxes into Excel as Text	Nick_adminator	Excel Discussion (Misc queries)	2	December 12th 07 05:56 AM
How do I link Text Boxes to Cells, not Cells to Text Boxes?	Ebby	Excel Worksheet Functions	1	May 15th 07 11:31 PM
In Excel, option to enter text in cells the same as text boxes	RobGMU	Excel Worksheet Functions	0	October 26th 05 04:20 PM

All times are GMT +1. The time now is 01:53 AM.

Menu

About Us