Ciao All ~
Would like to chart/visualize item trends based on final auction prices. Not sure how to split a String based on the Date format.
Here's the original String : "$1,334.00May-21 17:19or Best OfferFree Shipping"
The date format is consistent throughout all the strings. Simply looking to split a column these in three parts.
Dollar Amount | Date Format | "Rest of String"
Appreciate your help in advance.
Artikyulashun
Please also show other rows as an example.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Here are a few more relative string examples if needed :
$109.00Apr-9 18:57or Best Offer+$4.20 shipping
$112.50Apr-30 09:0421 bids+$4.20 shipping
$164.95Apr-21 12:30or Best Offer+$3.80 shipping
$2,299.99May-22 15:00or Best OfferFree Shipping
$25.00Mar-27 10:55Buy It NowFree Shipping
B1 =LEFT($A1,SEARCH(".",$A1,1)+2) and drag down
C1 =MID($A1,LEN($B1)+1,SEARCH(":",$A1;1)-LEN(B1)+2) and drag down
D1 =RIGHT($A1,LEN(A1)-(LEN(B1)+LEN(C1))) and drag down
The C1 Formula appears to be amiss. Is it the SEARCH function?
Looks like : =MID($A1,LEN($B1)+1,SEARCH(":",$A1;1)-LEN(B1)+2)
Should be : =MID($A1,LEN($B1)+1,SEARCH(":",$A1,1)-LEN(B1)+2)
Perfect. Thank you for very much for the assist!
Wij houden van Oranje! [ Father was born in the small town of Monster. :-) ]
Typo ; instead of ,
Looks like : =MID($A1,LEN($B1)+1,SEARCH(":",$A1,1)-LEN(B1)+2)
Oh the well known town Monster in the area of The Hague.
That'd be the one ... not sure what it is well known for outside of the name though.
I am just joking.It is a small village, so of course it is not well know to other people.
Thanks for the rep.
Glad I could help.
If you are satisfied with the solution, please mark the question solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks