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

02-04-2018, 02:16 PM

p45cal

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

Office 2010 32bit

Expert

Join Date: Apr 2014

Posts: 956

Code:

Spaces = Application.Trim(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Application.Trim(strText), ".", ". "), " -", "-"), "- ", "-"), " *", "*"), "* ", "*"), "(", " ("), ")", ") "), "( ", "("), " )", ")"))

« 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 09:31 AM.