space

  • Thread starter Thread starter Loi
  • Start date Start date
L

Loi

Hi,

First Name typed in column A. However, these name are not
straght in the column.
Ex: Huong
Nguyen
Long
 
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.
 
use the function trim and it will align your data in the
column.

e.g.

A2
Houng
=trim(A2)

Result
A2
Houng
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

space 4
Lettters 3
Capitalize the first letter 5
Subtotals - show all columns? 2
Search and add 3
Pesky spaces 1
Excel Comparing two columns 1
HOW DO I COMBINE two spreadsheets into one by names in column a 3

Back
Top