LinkBack URL
About LinkBacks
ExcelSpaces.jpg
Curious if there a macro for cleaning up data that has more than 2x spaces. E.g. delete or clear out spaces that are two or more.
Any suggestion is welcome! Thanks!
ExcelSpaces.jpg
Curious if there a macro for cleaning up data that has more than 2x spaces. E.g. delete or clear out spaces that are two or more.
Any suggestion is welcome! Thanks!
Hi, PaulLor89,
only guessing as no row numbers are given: if it´s inside a cell look for consecutive line feeds (Chr(10)/vbLf or Chr(13)/vbCr) in a loop and replace the two of them by one.
Ciao,
Holger (who´s versions of Excel aren´t able to convert images into worksheets)
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
SampleData.xls
Haha, I've took a screen shot.. The excel file has a ton of rows/data.
Anywho, I am looking to clean up column I specifically, "Service Specific Notes" but all others will be great too. The data was pulled from an ERP system and whoever entered it is rather messy. I am creating a report that I need to generate on a monthly basis. Would be great to have a macro/code for me to run instead of going into each individual cell and deleting the extra spaces. I don't understand what you mean by (Chr(10)/vbLf or Chr(13)/vbCr) in a loop and replace the two of them by one.... I am a true noob.
Hi, PaulLor89,
give this code a try:
Ciao,
Please Login or Register to view this content.
Holger
Thank you Hahobe, works great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks