Get text after a specific word

[soncoku]

Hey everyone.

I have a bank statement from which I need to copy the currency: and Name of Account:

As you can see in the picture they are both in the same column.
I want to copy what's after Currency: EUR

and also what's after Name of Account : Company name.

Then add the currency value EUR to a new column called Currency
and Name of account value Company name to a new column called Account

[LordNeilLord]

Hey @soncoku 

The easiest way would be to use text to columns and use : as the delimiter

Or you could do some regex like Currency:(.*) to parse everything after the colon 

[soncoku]

@LordNeilLord 

I am stuck at this point:
Currency:(.*)

because I want it to go all the way down, till the end of the column.

Currency: EUR
Name of the account: The Company
Date	Transaction ID	Receiver	Tranasction Type	Amount	Account	Currency
11/11/2011					The Company	EUR
					The Company	EUR
					The Company	EUR
					The Company	EUR

So Two new columns should be created and they should continue till the end of these rows.

[danilang]

Hi @soncoku 

To copy the values down, you can use a Multi-Row tool for each of the columns.  

Dan

[echuong1 · Accepted solution]

Does the attached work for you?

Essentially, I used text to columns to parse out the currency and account values. From there, I used multirow formulas to drag down the currency and account values. A select tool finishes it to clean up the columns!