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

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

View Single Post

Old

06-17-2016, 03:51 AM

jhato160

jhato160 is offline

jhato160 uses Windows 10

Windows 10 jhato160 uses Office 2016

jhato160 uses Office 2016

Office 2016

Novice

The original poster

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