Spacing

[Asussertown]

On occasion, as I input new data into cells, I notice that the text in some
cells have a slightly different left margin. I checked for font name, size,
and alignment, but there is no difference.

 

[Don Guillett]

try using TRIM

 

[Asussertown]

Boy, I've never heard of that one. How do you get to it? I'm only talking
about on-screen.

 

[Peo Sjoblom]

You would need a help column and use the function

=TRIM(A1)

copy down and the copy and paste special values, then either
copy over old values or delete the old values..
Or you could run a macro if this happen often


http://www.mvps.org/dmcritchie/excel/join.htm#trimall

 

[Asussertown]

in this case I am not using any formulas or numbers, just words

 

[Dave Peterson]

The =Trim() function is used to get rid of leading and trailing spaces (and
redundant internal spaces).

If you don't have leading spaces, then this won't solve your problem.

There's an option that doesn't sound like you would have used, but you may want
to check--just to eliminate it.

Select the cells with the margin problems.
Format|Cells|Alignment tab.
Make sure that Indent box is set for 0.

====
If that's not it, can you describe the problem further (but don't attach a
workbook).

Are all the cells in the same column?
Are you typing the values (or cutting from another application--like Internet
Explorer)?

(If yes to the MSIE question, try Peo's suggestion of David McRitchie's TrimAll
macro. Sometimes there's extra (looks like spaces, but not) characters pasted
in the cell.)