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?

02-01-2018, 05:17 PM

p45cal

Windows 10 How to remove trailing & leading spaces in a cell?

Office 2010 32bit

Expert

Join Date: Apr 2014

Posts: 962

This might do it:

Code:

Private Function Spaces(strText As String) As String
Spaces = Replace(Replace(Application.Trim(strText), "( ", "("), " )", ")")
End Function

If not, supply a bunch of strings with before and after expectations.

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 03:52 PM.