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!
Hi, welcome to the forum
Have you tried the TextToColumns function under trhe Data tab?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
HA! That was easy! Thanks so much!
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)
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.
I had a feeling you would come back and ask that lol
I got this formula from 1 of the other senior members (some time back) and modified it for your use...
Total $14,214.00 0.00 0.00 -$14.95 -$661.97 $13,537.08 Total $14,214.00 0.00 0.00 -$14.95 -$661.97 $13,537.08
D5=TRIM(MID(SUBSTITUTE($D$4," ",REPT(" ",LEN(D$4))),LEN($D$4)*(ROW()-5)+1,LEN($D$4)))
copied down
Perfect! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks