ExcelBanter - Removing Spaces in a Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Removing Spaces in a Cell (https://www.excelbanter.com/excel-worksheet-functions/5269-removing-spaces-cell.html)

carl

Removing Spaces in a Cell

Is there an eay way to remove spaces in a range of cells ?

Thank you in advance.

Frank Kabel

Hi
see:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
Regards
Frank Kabel
Frankfurt, Germany

"carl" schrieb im Newsbeitrag
...
Is there an eay way to remove spaces in a range of cells ?

Thank you in advance.

Dave Peterson

Select the range
edit|replace
what: (spacebar)
with: (leave blank)
replace all

carl wrote:

Is there an eay way to remove spaces in a range of cells ?

Thank you in advance.

--

Dave Peterson

All times are GMT +1. The time now is 10:05 AM.