space

L

Loi

Hi,

First Name typed in column A. However, these name are not
straght in the column.
Ex: Huong
Nguyen
Long
 
R

Rich Dolny

If the first suggestion doesn't work you may want to try
this.

You may have inadvertently put a blank space (by hitting
the space bar) in front of the name. Put your cursor
infront of the first letter in the name and hit your
backspace key. If it moves the name over to the left then
thats what it was. Let me know if this worked.

Hope this help.
 
R

Rojee

use the function trim and it will align your data in the
column.

e.g.

A2
Houng
=trim(A2)

Result
A2
Houng
 
Top