crear una funcion VBA elimine espacios en blanco extras en excel

requiero crear una funcion VBA elimine espacios en blanco extras de un string (cadena de texto) en excel.


cadena de ejemplo 2 ===> cadena de ejemplo 2

usando solo codigo VBA no macros, yo intente con TRIM pero solo elimina primer y ultimo espacios extras de una cadena de texto pero NO elimina los espacios extras del medio de la cadena!

Taidot: Excel

Näytä lisää: excel scraper google search result vba, excel data entry form codeing vba, excel add reference ms word vba, excel output xml file using vba, excel 2007 find sheet name vba, excel yahoo finance historical data vba, excel sum multiple cell column vba, excel sheet data extraction pdf vba, excel yahoo finance data download vba, excel sheet check web links vba, save excel file older version using vba, excel macro historical stock quote vba, excel column entry proper function vba macro samples, unlock excel password protected cut paste vba, data excel workbook master workbook using vba

Tietoa työnantajasta:
( 21 arvostelua ) Bogota, Colombia

Projektin tunnus: #13107386

Myönnetty käyttäjälle:


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 Lisää

$15 USD 0 päivässä
(217 Arvostelua)

5 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 detail Lisää

$25 USD 1 päivässä
(134 arvostelua)

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.

$25 USD 1 päivässä
(13 arvostelua)

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

$15 USD 0 päivässä
(28 arvostelua)
$25 USD 1 päivässä
(0 arvostelua)