Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 06-17-2016, 03:51 AM
jhato160 jhato160 is offline Data Entry - Getting spreadsheets back with excess space but the TRIM function doesn't work Windows 10 Data Entry - Getting spreadsheets back with excess space but the TRIM function doesn't work Office 2016
Novice
Data Entry - Getting spreadsheets back with excess space but the TRIM function doesn't work
 
Join Date: Jun 2016
Posts: 13
jhato160 is on a distinguished road
Default

=TRIM(CLEAN(SUBSTITUTE(LEFT(TRIM(A7),LEN(TRIM(A7))-OR(RIGHT(TRIM(A7))={"?","!","."})),CHAR(160)," ")))

This function was the winner. Holy **** that was cool.

Last edited by Pecoflyer; 06-17-2016 at 06:10 AM. Reason: Deleted unappropriate word
Reply With Quote
 

Tags
extra spaces, trim



Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook Calendar goes back to start screen each time I put a new entry in Exhale Outlook 0 04-24-2016 02:01 AM
Adding a carriage return at end of each line, and then a blank space, after text entry complete CEMurphy4 Word VBA 1 12-02-2015 11:53 PM
Data Entry - Getting spreadsheets back with excess space but the TRIM function doesn't work Copy data from spreadsheets to a two, with the sum criterion marreco Excel Programming 1 05-15-2012 04:15 PM
Help getting lost work back!!! jcb08j Word 0 03-06-2012 08:11 AM
Data Entry - Getting spreadsheets back with excess space but the TRIM function doesn't work trimming excess image data in Word document gib65 Word 2 12-13-2011 07:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft