If it actually text that was indented then you can use the decrease indent
button.
You can also downloas the ASAP utility http://www.asap-utilities.com/ it is
free and has a tool to remove leading and or trailing spaces.

"SteveG" wrote:


In a helper column to the right use,

=TRIM(A1)

where A:A is your values. Copy down the list. Then Paste Special
Values over the old text. Delete the helper column.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=513733