LinkBack URL
About LinkBacks
Hi
I have numbers in this format which is not formatted as a date.
11/06/2018
Could you pls help me with the formula to extract the numbers (i.e. 2018) after the second dash?
thanks
Hi
I have numbers in this format which is not formatted as a date.
11/06/2018
Could you pls help me with the formula to extract the numbers (i.e. 2018) after the second dash?
thanks
Try
=RIGHT(A2,4)+0
Thanks for the rep!
What if the length isn't always 4 digits ?
PHP Code:=RIGHT(A1,LEN(A1)-FIND(CHAR(160),SUBSTITUTE(A1,"/",CHAR(160),2)))
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks