remove space preceeding text

[mark91345]

Hi,
I keep having these "spaces" preceeding my text that I want to remove... but how do I do it globally? I don't know how to show an excel table in my email, so please be patient with me. As you can (hopefully) see, my row headers and columnar information is off by one space. How can I remove the space WITHOUT removing the space from the "city" column (i.e. Twin Falls, not TwinFalls)?

<table width="568" border="0" cellpadding="0" cellspacing="0"><col style="width: 58pt;" width="77"> <col style="width: 47pt;" width="62" span="2"> <col style="width: 125pt;" width="167"> <col style="width: 104pt;" width="138"> <col style="width: 47pt;" width="62"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 58pt;" width="77" height="20">call</td> <td class="xl65" style="width: 47pt;" width="62">freq</td> <td class="xl65" style="width: 47pt;" width="62">am_fm</td> <td class="xl65" style="width: 125pt;" width="167">genre</td> <td class="xl65" style="width: 104pt;" width="138">city</td> <td class="xl65" style="width: 47pt;" width="62">st</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20"> KACH </td> <td class="xl65"> 1340</td> <td class="xl65"> AM</td> <td class="xl65"> Oldies </td> <td class="xl65"> Preston </td> <td class="xl65">id</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20"> KAGF
</td> <td class="xl65"> 105.5</td> <td class="xl65"> FM</td> <td class="xl65"> Religious </td> <td class="xl65"> Twin Falls </td> <td class="xl65">id</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> </tr> </tbody></table>

 

[mark91345]

okay, now when I NEED the columns to show they're off, they line up in the email.
OY.

 

[CWatts]

Try using the TRIM function.

So assuming A1 you have " Twin Falls", "Twin Falls" or "Twin Falls "

just use =TRIM(A1)

 

[mark91345]

remove leading spaces

Thanks for your help.

I found a "treasure" directly from Excel's help menu. It is an add-in http://office.microsoft.com/en-us/marketplace/trim-spaces-for-excel-EM010238773.aspx?redir=0

It works for current and older versions. I was amazed at how easily it got rid of the leading spaces I had, so I wanted to pass it along.

Mark