Hi Everyone,

I need help with a certain problem i'm stuck at in vba

The situation is like this:

I have a cell with the value
"1.0-73|Event_Id|DealIdFO|Context|Validation_Id|Validat ionStatus_Id|Validated|EventDate|EventType|Categor y|InternalStatus|AccountingFlag|Action|FODeal_Id_F irst|BODeal_Id|Description|Users_Id_FO|BOCaptureDa te|Entity_Id|BODeal_Id_Father|BODeal_Id_First|FODe al_Id_Father|Version|CorporateActionKey_Id|Securit ies_Id|Securities_ShortName|SecuritiesType|LegSecu rities_ShortName|LegSecuritiesType|Securities_Pair s_ShortName|Securities_Options_ShortName|Securitie s_Futures_ShortName|Definition|OptionStrike|Maturi ty|LastTradeDate|DealLeg|Folders_Id|Amount|Princip alCur1|PrincipalCur2|ForwardAmountCur1|ForwardAmou ntCur2|Currencies_Id|Currencies_Id_1|Currencies_Id _2|DifferentialCur1|DifferentialCur2|StartDate|End Date|Rate|FloatingRates_Id|AdditiveMargin|Multiply Margin|Principal|Strike|PaymentDate|Pairs_Id|Index ation|Quantity|Price|ThirdParty_Id_Cpty|DealType|D ealSubType|ClientMargin|OptionType|EventCustomType _Id|EventCfg_Id|VersionNumber|ActionDate|OriginalE ventDate|ActionDetail|Event_Id_Previous|CollatAgrt _Id|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X| X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X| X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X| |||||||||||||||||||||||||||||||||||||||||||||||||| ||||||||||||||||||||||||50|||||||||||||||||||||||| |||||||||||||||||||||||||||||||||||||||||||||||||1 |13|0|6|2|3|4|5|7|8|9|10|11|12|14|15|16|17|18|19|2 0|21|22|23|24|25|26|27|28|29|30|31|32|33|34|35|36| 37|38|39|40|41|42|43|44|45|46|47|48|49|50|51|52|53 |54|55|56|57|58|59|60|61|62|63|64|65|66|67|68|69|7 0|71|72||A|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X |X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X |X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X|X |X|X|X|"

As you can see, there is alot of data in one particular field and it is not
typed manually as it is extracted from the database.

I would like to know if there is a coding that allows me to be able to
separate this value in the cell into different rows separated by the " | "
sign and to paste only numeric values on the next sheet.

Would be really great if you can help me out!