|
|
#1
01-31-2018, 02:36 PM
|
|||
|
|||
How to remove trailing & leading spaces in a cell?
How can I remove the trailing & leading spaces even if it is in brackets from the cell?
The following code is fine but for MS Access. How can I use the similar code in Excel to get the result? Code:
Private Function Spaces(strText As String) As String
Return String.Join(" ", strText.Split({" "}, StringSplitOptions.RemoveEmptyEntries)).Replace("( ", "(").Replace(" )", ")")
End Function
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can I remove spaces between only Chinese characters? | sivartnosredna7 | Word | 2 | 01-09-2017 05:33 AM |
| How to remove spaces from Cells which are at the end of value? | LearnerExcel | Excel | 2 | 12-19-2016 01:10 PM |
 Mail Merge - Trailing Spaces
|
osucjb | Mail Merge | 5 | 10-28-2016 12:03 AM |
| Get rid of leading spaces before paragraphs | fig000 | Word | 11 | 03-14-2016 01:59 PM |
| editing text and remove spaces | romanticbiro | Word VBA | 5 | 07-04-2014 07:42 PM |
Windows 7 32bit 
Office 2003
Threaded Mode