I have a text string. It has dates such as
"2001-2004"
or "2002-2010"
Is there any way I can use a formula to remove the dates only? Given that they are variable, I am having a hard time making a formula.
I want to rearrange the date location in a text string.
Still open, looking for answer.
Not a lot to go on.
Do you mean something like this?
formula in B1 and filled down.Formula:
Please Login or Register to view this content.
Dave
It could be shorter
Formula:Please Login or Register to view this content.
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
Clever. I like it.Originally Posted by AlKey
I have feeling we will not live to see year 300
Last edited by AlKey; 09-19-2017 at 07:51 AM.
After surviving that hurricane I would think optimism would be in your DNA.
Thanks for the replies everyone.
I tried the above suggested formulas and they either selected from the wrong spot, or selected the wrong text. Given that the year ranges change within the text, would a character count help for designing a function? Or exact examples?
Also, once I have the year range separated out, would there be a way to delete it within the source data, but dragging a formula?
Then I assume I could add it back it where I need with conc. function.
Thanks again
savent79 it sounds like you need to upload an Excel sample file with a data mix representative of what you are working with ... (please no pics or screenshots. It saves having to retype data.)
If you are not familiar with how to do this:
To attach a file to your post,
- be sure to desensitize the data
- click “Go Advanced” (next to Post Quick Reply – bottom right),
- scroll down until you see “Manage Attachments”, click that,
- click “Browse”.
- select your file(s)
- click “Upload”
- click “Close window”
- click “Submit Reply”
The file name will appear at the bottom of your reply.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks