Get instant live expert help on I need help with excel split string by space
“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
Possibly creating some code string formula to help split jumbled data, hard to explain
Solved by T. J. in 19 mins
How can i split a number in 1 cell by 30% 30% 30% and 10%?
Solved by C. F. in 30 mins
I need help totaling grouped amounts in my column that are separated by a space.
Solved by M. H. in 20 mins
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
FORMULA TO PERFORM A MATHEMATICAL EQUATION ON A SET OF NUMBERS WITHIN A STRING OF NUMBERS, THEN REPLACE THE SET OF NUMBERS WITH THE MATHEMATICAL RESULT IN THE SAME STRING OF NUMBERS
(EXAMPLE: 123456 STRING OF NUMBERS, & MATHEMATICALLY REDUCE THE MIDDLE NUMBER OF 34 BY 1, THEN REPLACE THE ANSWER TO THE ORIGINAL STRING RESULTING IN 123356)
Solved by D. J. in 30 mins