 # 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