Posted to microsoft.public.excel.programming

camlad

external usenet poster

Posts: 28

White space removal

I need to remove white space from a range so I recorded the following which
did not work.

How can I remove all spaces in a range?

Range("A1:A535").Select

Selection.Replace What:="^w", Replacement:="", LookAt:=xlPart, _

SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

ReplaceFormat:=False

Camlad

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
Space removal - a first name,space last name	Tech Express	Excel Discussion (Misc queries)	4	February 9th 09 08:24 PM
Remove All White Space	Carol	Excel Programming	1	November 17th 08 01:02 PM
white space deletion	JOMARFL	Excel Worksheet Functions	2	February 2nd 07 08:43 PM
White Space in PDF from Excel	Antony	Excel Discussion (Misc queries)	0	May 23rd 05 08:21 PM
Inefficient Space Removal	Sauron	Excel Programming	5	January 2nd 04 11:03 AM

All times are GMT +1. The time now is 05:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us