Re: desperate... trim function issue...

From: LEB (anonymous_at_discussions.microsoft.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 05:11:43 -0800

Correct. To eliminate the manual work, this whole process
could be recorded as a macro.
>-----Original Message-----
>You can do that, it's a bit more work than using a
macro,
>but either way you want to first format the column as
text;
>otherwise, you will lose the leading zero of the zip
codes
>that begin with a zero.
>
>"LEB" <anonymous@discussions.microsoft.com> wrote in
message news:72b701c40257$0b55f710$a001280a@phx.gbl...
>> Seems you could just select the column containing the
>> Zips, press CTRL-H to invoke the replace command, and
>> replace the space character with nothing. Just press
the
>> space bar when the cursor is in the Find What box,
leave
>> the replace With box empty, and click the Replace All
>> button.
>
>
>.
>