Pick from cell value

[b13]

Hi guys,

I want to know how to pick values to a certain cell. For example this one:

<TABLE style="WIDTH: 1343pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1790><COLGROUP><COL style="WIDTH: 1343pt; mso-width-source: userset; mso-width-alt: 65462" width=1790><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 1343pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 width=1790>Details of payment:| IN05184816 IN05184780 IN05184767|Beneficiary customer:| /NO4371590441575| SEAGULL AS| GAMLEVEIEN 36| P.O. BOX 1062 N-3194 HORTEN| NORWAY|Beneficiary bank:| DNB NOR BANK ASA (FORMERLY DEN NORS|Original amount:| 8,858.00 USD|Exchange rate:| 1.00000000|Settle Value date:| 09FEB12|Own Ref:| --8916.9--|Bank Reference No.:| P1202090253OP08|Related to payment No.:| 0000046702</TD></TR></TBODY></TABLE>
The above mentioned are in one cell. The only value i wanted to get are the highlightened in orange. I already tried the delimited function, wherein we can set divisions to a range of cell but it didnt work.

Maybe a formula that will let me pick from the character ( " | " ) - ( "|"), since all are divided with that character.


Appreciate your help guys,

Thanks a lot.

 

[hiker95]

b13,

Excel Workbook
	A	B
1	Details of payment:| IN05184816 IN05184780 IN05184767|Beneficiary customer:| /NO4371590441575| SEAGULL AS| GAMLEVEIEN 36| P.O. BOX 1062 N-3194 HORTEN| NORWAY|Beneficiary bank:| DNB NOR BANK ASA (FORMERLY DEN NORS|Original amount:| 8,858.00 USD|Exchange rate:| 1.00000000|Settle Value date:| 09FEB12|Own Ref:| --8916.9--|Bank Reference No.:| P1202090253OP08|Related to payment No.:| 0000046702	IN05184816 IN05184780 IN05184767
Sheet1

 

[b13]

Hi Hiker95,

Thanks a lot

 

[hiker95]

b13,

You are very welcome.

Glad I could help.

Come back anytime.

 

[b13]

I will Hiker95....

Thanks again