Data Entry - Getting spreadsheets back with excess space but the TRIM function doesn't work

		Microsoft Office Forums > Microsoft Excel > Excel
Data Entry - Getting spreadsheets back with excess space but the TRIM function doesn't work

FAQ

Thread Tools

Display Modes

06-17-2016, 03:51 AM

jhato160

Windows 10 Data Entry - Getting spreadsheets back with excess space but the TRIM function doesn't work

Office 2016

Novice

Join Date: Jun 2016

Posts: 13

=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

Tags

extra spaces, trim

« Previous Thread | Next Thread »

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
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
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 08:11 AM.