Leading Spaces in a column

Perhaps:

=MID(A1,2,8)

This would assume your data is text, and that there is only
ONE leading 
space (hence the "2" for beginning at the second
space.  If there were 2 
leading spaces, use "3", etc.  The "8"
could be anything, but it needs to be 
the number of characters you have.  If the number of
characters varies, I 
believe you will be OK if you choose the number based on the
largest number 
of characters in any one cell.


>From: Claudia Satori <TotaTuaVERIZON.NET>
>Reply-To: MS Excel General Q & A List
<EXCEL-GPEACH.EASE.LSOFT.COM>
>To: EXCEL-GPEACH.EASE.LSOFT.COM
>Subject: Leading Spaces in a column
>Date: Fri, 29 Dec 2006 13:49:10 -0800
>
>I have a column that after the text to column and
concatenation has a
>leading space. How can I EASILY get rid of the leading
space?
>--
>Claudia
>Excel 2K3 on PC
>Excel 2K4 on MAC
>Yes I go both ways 
>
>--------------------------------------------------------
------------------
>The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
>international's LISTSERV(R) software.  For
subscription/signoff info
>and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
>http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

____________________________________________________________
_____
From photos to predictions, The MSN Entertainment Guide to
Golden Globes has 
it all. http://tv.msn.com/tv
/globes2007/

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G