<div>
=IF(LEN(TRIM(A1)),REPLACE(LEFT(A1,LOOKUP(2^15,FIND(RIGHT(TRIM(A1)),A1,ROW(INDIRECT(&quot;1:&quot;&amp;LEN(A1)))))),1,FIND(LEFT(TRIM(A1)),A1)-1,&quot;&quot;),&quot;&quot;) 
 
Courtesy barryhoudini
</div>

=IF(LEN(TRIM(A1)),REPLACE(LEFT(A1,LOOKUP(2^15,FIND(RIGHT(TRIM(A1)),A1,ROW(INDIRECT("1:"&LEN(A1)))))),1,FIND(LEFT(TRIM(A1)),A1)-1,""),"")

Courtesy barryhoudini

<div>
=TRIM(your cell address) &nbsp; didn't do anything. &nbsp;I copied the formula into the space at the top of the spreadsheet as =TRIM(C2) which is the real field I want trimmed and nothing happened other than =TRIM(C2) appeared in cell D2 ??????????? 
 
 
The same thing happens with... &nbsp; =IF(LEN(TRIM(A1)),REPLACE(LEFT(A1,LOOKUP(2^15,FIND(RIGHT(TRIM(A1)),A1,ROW(INDIRECT(&quot;1:&quot;&amp;LEN(A1)))))),1,FIND(LEFT(TRIM(A1)),A1)-1,&quot;&quot;),&quot;&quot;) 
 
The formula just appears in D2. 
 
I'm sure I'm doing something wrong.
</div>

=TRIM(your cell address)   didn't do anything.  I copied the formula into the space at the top of the spreadsheet as =TRIM(C2) which is the real field I want trimmed and nothing happened other than =TRIM(C2) appeared in cell D2 ???????????


The same thing happens with...   =IF(LEN(TRIM(A1)),REPLACE(LEFT(A1,LOOKUP(2^15,FIND(RIGHT(TRIM(A1)),A1,ROW(INDIRECT("1:"&LEN(A1)))))),1,FIND(LEFT(TRIM(A1)),A1)-1,""),"")

The formula just appears in D2.

I'm sure I'm doing something wrong.

Clean-external-spaces.xlsx

<div>
<div class="content wysiwyg-content">
How can I remove all spaces following the last character in a cell? &nbsp;In other words... 
 
&quot;# 264,265 BTMPI, # 266 &nbsp;CLINK &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;53 after &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&quot; 
 
would end up like... 
 
&quot;# 264,265 BTMPI, # 266 &nbsp;CLINK &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;53 after&quot; 
 
(without the quote marks) 
 
--Steve
</div>
</div>

How can I remove all spaces following the last character in a cell?  In other words...

"# 264,265 BTMPI, # 266  CLINK                  53 after            "

would end up like...

"# 264,265 BTMPI, # 266  CLINK                  53 after"

(without the quote marks)

--Steve

How can I remove all spaces following the last character in a cell

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.