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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:45 PM.