Sharukh Ali commented on a post on Blogger.
i want only amounts which is after second (|) some time its in 3 digits and some times 4 or 5 digits


is there any small formula



Excel data is

774857|Fos|350|Main|Green|2234|

97868|Fos|4500|Main|Green|46577|




i mean i want only that amount which is between 2nd and 3rd (|)



Results should be 350 and 4500 for this data
Shared publicly