Bank Reference number

[Shabbo]

Dear Sir,
Can I get 12 digit reference numbers from right side after first “-“ as shown in column B2.

 

[Naresh Yadav]

Dear Shabbo,

you can do it by selecting the column and than go to Text to column ->select delimited->Next->select->"-" in other delimiter->next ->finish

 

[vletm]

Shabbo
Why did You open a new thread?
Your previous thread is still open : https://chandoo.org/forum/threads/bank-reconciliation-help.41836/

You could add more needed information to there.
... closed ...