I need to split database downloads into Unit Name and date. Unfortunately the data is separated by " - " but the Unit name may also have a hyphen.
See attached file with data sample, results needed and the complete unit name table.
Any assistance is greatly appreciated!
Hi there. How does this look?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
If you need to use the dtes for furether calculatons, try this
=--TRIM(TRIM(RIGHT(SUBSTITUTE(A3,"-",REPT(" ",25)),25))+0)
instead (made more awkward by US versus UK date formats. It works OK for me and SHOULD work for you).
Hi Glenn,
The date works great!
One other point that I did not mention is that the first characters of the data download changes, i.e., ( 7764 ) Tanya Skrivanic, represents a unique number but the name and number change. It could be ( 999 ) Glen Kennedy, Unfortunately that was not in the data sample.
Lastly, in your file column F, the "( 7763) Tanya Skrivanic - " should not be in the results. Just "Barnacle". How would that change the formula given the varying length of the name and number?
I've never used trim and substitute, only Len. Thank you ever so much for the education.
Hi,
For date is suffice this formula : =--TRIM(RIGHT(SUBSTITUTE(A3,"-",REPT(" ",25)),25))
Dohh! Try this instead. (I really should READ what people ask more slowly!!).
Thank you! It will take me 2 days to figure out how it works, but it works beautifully!
FYI, I'm just as guilty of not reading the entire question before responding. I think it's inherent to computer users...
Have a great afternoon.
Thanks for the Reputation that you have added. It's much appreciated. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks