Re: Macro Question

Tech-Archive recommends: Speed Up your PC by fixing your registry

Select them all and Find and Replace, Ctrl-H, and replace " " with nothing

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"ALoecher" <ALoecher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0754BD0B-EEA0-4AAC-AC6D-4DF0DF00014C@xxxxxxxxxxxxxxxx
I feel dumb but I cannot figure out how to automate the TRIM function to
get
rid if the spaces in all the cells

"Gary''s Student" wrote:

The TRIM() function will do exactly what you want
--
Gary''s Student


"ALoecher" wrote:

I am a new Excel user and I am having some trouble. I split a column
of data
seperated by semicolons into several columns. Now I have a bunch of
cells
with a leading space and it is screwing things up when i try to sort
alphabetically. How can i create a macro do delete the leading space
in cells
that have such a space??


.

Relevant Pages

  • Re: VBA and VSTO
    ... Exactly Jos, ... Bob Phillips ... (remove nothere from email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: Counting Unique Values
    ... Bob Phillips ... (remove nothere from the email address if mailing direct) ... sumproduct will sum them to return 6, if we change the last number 4 to 1 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Figuring daily average...function ???
    ... Bob Phillips ... (remove nothere from email address if mailing direct) ... I'm keeping results of an investment. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: can Excel help to "count" votes...?
    ... Bob Phillips ... (remove nothere from email address if mailing direct) ... I'm wondering if Excel can help me "choose" the most popular art pieces ...
    (microsoft.public.excel)
  • Re: Pls help on Sumproduct with >1 data range
    ... Bob Phillips ... (remove nothere from the email address if mailing direct) ... I try to compare "column A VS partial column F" AND "column B VS ...
    (microsoft.public.excel)