Get instant live expert help on I need help with excel remove space before text

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need a formula for macros or vba to settup for excel sheet for giving spaces for the amount entered. I am showing the example below for $ 2,636,640.77 AND $ 1,403.27=Space not given $ 4,109,547.74 AND $ 639.26=Space not given $ 6 , 216 , 423.72 AND $ 1 , 919.08=Space given before comma(,) and after comma(,)- 2 space $ 5 , 185 , 619.30 AND $ 2 , 618.01=Space given before comma(,) and after comma(,)- 2 space $ 3 , 175 , 558.82 AND $ 1 , 833.00=Space given before comma(,) and after comma(,)- 2 space
Solved by K. L. in 18 mins
Need to remove space and prepend and append current array formula
Solved by X. W. in 24 mins
i need a formula that remove a space after all of the names
Solved by D. J. in 22 mins
I have a formula that sums a column and adds a space then a text value derived from another sheet. The result is giving me the whole value then a decimal and 9 zeroes. When I remove the code to add the text value the formula returns a correct single decimal place value.
Solved by M. A. in 14 mins
I need a formula to combine text data in one cell with text in another however I need to remove e from words before adding the text EG Data entered into field = like next line should read likes a hidden column will have s next line liking ing next line liked ed Only e needs to be removed before ing or ed can be added
Solved by X. C. in 25 mins