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

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