Hi all; I need a formula on B1:BX , Thanks in advance.
Somendra Misra Excel Ninja Oct 2, 2014 #2 Hi, Try: =TRIM(SUBSTITUTE(A2," ","")) and copy down. Regards,
R Rui Pires Member Oct 2, 2014 #3 Really thanks Somendra , you are the best one more thing : the function Trim is not required,however,is there a way to center the value without the need to resort to formatting,like =--(x) for the date format?
Really thanks Somendra , you are the best one more thing : the function Trim is not required,however,is there a way to center the value without the need to resort to formatting,like =--(x) for the date format?
Somendra Misra Excel Ninja Oct 2, 2014 #6 Well formula cannot align the result. I fear you have to do it manually. Regards,
bobhc Excel Ninja Oct 2, 2014 #8 If you do not need the contents to be trimmed then do as Somendra suggests and select cells and center align.
If you do not need the contents to be trimmed then do as Somendra suggests and select cells and center align.