remove blanks from a string of chars within a cell?
|
|
All the blanks?
=SUBSTITUTE(A1," ","") Lots of cells and permanently - Select range and use Edit / Replace, replacing space with nothing. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "rayhollidge" wrote in message ... |
Hi Ray,
When posting please include the question in the text body. Not everything that appears to be a space is a space, frequently when copying from HTML you will copy a non-breaking space character ( ) or char(160) also known as a required blank (RBL) in some places. http://www.mvps.org/dmcritchie/excel/join.htm#trimall --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "rayhollidge" wrote in message ... |
All times are GMT +1. The time now is 03:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com