How to remove trailing & leading spaces in a cell?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to remove trailing & leading spaces in a cell?

FAQ

Thread Tools

Display Modes

01-31-2018, 02:36 PM

LearnerExcel LearnerExcel is offline

Windows 7 32bit How to remove trailing & leading spaces in a cell?

Office 2003

Advanced Beginner

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:48 AM.