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!”
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