crear una funcion VBA elimine espacios en blanco extras en excel

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel projects (with both formulas and macros) and i've never had a single problem. If you are interested, please attach me a sample file/s so i can see what exactly needs to be done. Removing the extra space (from both start and finish of the string, as well as inside a string, can be achieved with VBA). As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect. Thanks, Milan Hi jpm9370, Thanks for awarding me your project, can you please create a milestone so that we can begin working together?

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further details. Thanks and regards Roy

So the space needs to be removed from the beginning or from the end of the string. Can you please share sample excel sheet. I will do it right now.

Hello, you can use a simple Excel function to remove all spaces from the string, VBA is not needed. Example: " Remove all Spaces " -> "RemoveallSpaces" Regards