how to extract narration from combined data in a cell

[m9vukyem]

please find attachemnt

 

[Michael Gramm]

In I2 type : cash trans chrg for amt
Press enter and then hit Ctrl + E

 

[m9vukyem]

I need a formula that extract from b column

 

[bosco_yip]

I need a formula that extract from b column

In order not to repeat the answer, please give us more example data to cover all of your requirements.

Then,

We shall give you a single formula reply based on your revised data sheet.

and,

What is your Excel version you are using?

Thank you.

 

[m9vukyem]

i am using ms office 2016
we received bank statement from bank in that every transaction is in a single line including date. i am using text to columns function to separate date and using some other formulas to extract transaction amount but i am unable to extract narration part as mentioned in the h column

 

[Marc L]

So a better way is to directly import the data via Power Query (Get & Transform) or a VBA procedure whatever …​

​

 

[bosco_yip]

i am using ms office 2016
we received bank statement from bank in that every transaction is in a single line including date. i am using text to columns function to separate date and using some other formulas to extract transaction amount but i am unable to extract narration part as mentioned in the h column

You did not reply to my 1st question,

So,

Did your 1st file is your final format without further addition or revision?

Regards

 

[m9vukyem]

that is the final one

 

[bosco_yip]

that is the final one

Try,

1] Define 3 Names as in:

• Name: Particular
• Refers to: =$B2

• Name: RemoveTransactionAmt
• Refers to: =MID(Particular,2,MATCH(2,1/(CODE(MID(Particular,ROW($1:$99),1))>96))-1)

• Name: RemoveTransactionName
• Refers to: =MID(RemoveTransactionAmt,MATCH(TRUE,ABS(CODE(MID(RemoveTransactionAmt,ROW($1:$99),1))-77.5)<13,)-1,99)

Then

'2] In "Result" I2, formula copied down:

=MID(RemoveTransactionName,FIND(" ",RemoveTransactionName)+1,99)

 

[m9vukyem]

Thankyou sir