# Split long string to multiple cells

1. ## Split long string to multiple cells

Can someone please tell me how I can separate the long string below into 7 separate columns?
The string below is in cell D4. I need "Total" in D5, \$14,214.00 in D6, 0.00 in D7, 0.00 in D8, -\$14.95 in D9, -\$661.97 in D10, \$13,537.08 in D11.
Each of the numbers could be larger or smaller from month to month, meaning \$13,537.08 could become \$7,897.00 and 0.00 could become 110.00

Total \$14,214.00 0.00 0.00 -\$14.95 -\$661.97 \$13,537.08

Thank you!

2. ## Re: Split long string to multiple cells

Hi, welcome to the forum

Have you tried the TextToColumns function under trhe Data tab?

3. ## Re: Split long string to multiple cells

HA! That was easy! Thanks so much!

4. ## Re: Split long string to multiple cells

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)

5. ## Re: Split long string to multiple cells

This did help separate the string in my example as a one off, but what I'm really looking for is the ability to paste a string into D4 each month and have cells D5 thru D11 automatically populate as I mentioned in my original example. This will help me do calculations automatically.

6. ## Re: Split long string to multiple cells

I had a feeling you would come back and ask that lol

7. ## Re: Split long string to multiple cells

I got this formula from 1 of the other senior members (some time back) and modified it for your use...

 D 4 Total \$14,214.00 0.00 0.00 -\$14.95 -\$661.97 \$13,537.08 5 Total 6 \$14,214.00 7 0.00 8 0.00 9 -\$14.95 10 -\$661.97 11 \$13,537.08

D5=TRIM(MID(SUBSTITUTE(\$D\$4," ",REPT(" ",LEN(D\$4))),LEN(\$D\$4)*(ROW()-5)+1,LEN(\$D\$4)))
copied down

8. ## Re: Split long string to multiple cells

Perfect! Thank you!

There are currently 1 users browsing this thread. (0 members and 1 guests)