Hello,
What I am trying to do is difficult for me to explain so let me just show you.
I would like to take the information below:
Company 4 Wheel Air Suspension Conversion Kit for 2002-2009 Audi A8
And extract the Make, Model and Year range and convert it into this:
Make=Audi|Model=A8|Year=2002|Year=2003|Year=2004|Year=2005|Year=2006|Year=2007|Year=2008|Year=2009
New to the community but I am willing to pay for assistance.
Thank you.
Scott B
Hello and welcome to the forum
Does the string always contain the year range in the format you show. i.e. 2002-2009 and always with a '-'.
Is it also the only occurrence of a '-' in the string?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Assuming text string in cell A1.
Enter this formula in B1 and pull it across to C1
Formula:
Please Login or Register to view this content.
and then enter formula in D1 and copy across until you see blanks.
Formula:Please Login or Register to view this content.
Last edited by AlKey; 09-10-2016 at 02:54 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks