Hi,
I'm not sure I understand the question exactly, but does this work?
=RIGHT($A$1,LEN($A$1)-FIND("<",$A$2))*1
Hi,
I'm not sure I understand the question exactly, but does this work?
=RIGHT($A$1,LEN($A$1)-FIND("<",$A$2))*1
oldchippy
-------------
![]()
![]()
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Hiya,
Yes, sorry I couldn't explain it very well. But your suggestion did work. Thank you
Glad to hear it - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks