say these are in A1 through A4.
BIOS Date: 09/01/15 20:17:33 Ver: A13.00
BIOS Date: 05/19/15 00:24:20 Ver: A12.00
BIOS Date: 05/01/14 23:18:57 Ver: A06.00
BIOS Date: 05/01/14 23:18:57 Ver: A06.00
I can't seem to get a formula to work to search the cell for *Ver:* and if it finds it, display the number to the right of it (without the space in front)
I thought this would be easy but I cant seem to get it to work.
Thank you.
If all the values to the right are six characters in length
=IF(ISNUMBER(SEARCH("Ver",A1)),RIGHT(A1,6),"")
or if the length varies
=IF(ISNUMBER(SEARCH("Ver",A1)),RIGHT(A1,LEN(A1)-SEARCH("ver",A1)-4),"")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thank you Special-K, this worked. Is it possible within the same "True" field to say only show the 3 characters so it says A13 instead of A13.00?
I know how to do it making another cell but is there anyway to do it all within one cell in the same formula?
Try
=IF(ISNUMBER(SEARCH("Ver",A1)),MID(A1,LEN(A1)-SEARCH("ver",A1)-4,3),"")
=MID(A1,FIND("Ver: ",A1)+5,LEN(A1)-(FIND("Ver: ",A1)+7))
However, this only works if those values are always at the far right of the cell. Are they in your case or is it sometimes in the middle? You could just replace the number of characters with 3 if it's always a fixed length after Ver:
=MID(A1,FIND("Ver: ",A1)+5,3)
Last edited by zlittle; 09-16-2016 at 12:25 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks