![]() |
|
|
Thread Tools | Display Modes |
#6
|
|||
|
|||
![]()
=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 |
|
![]() |
||||
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 |
![]() |
marreco | Excel Programming | 1 | 05-15-2012 04:15 PM |
Help getting lost work back!!! | jcb08j | Word | 0 | 03-06-2012 08:11 AM |
![]() |
gib65 | Word | 2 | 12-13-2011 07:50 AM |