Stripping out some text form a larger string

Closed
maillme Posts 1 Registration date Thursday February 2, 2017 Status Member Last seen February 2, 2017 - Feb 2, 2017 at 05:57 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 3, 2017 at 08:32 AM
Hi All,

I have very basic skills in excel - I'm trying to work through some data, and I have a long string of text - which has a common word "Naam:"

I'd like to take the piece of text after this (separated by a space) and use in another cell

So, take this for example in cell A1:

NL31RABO011254878 - BIC: RABPNL2U - Naam: N.D. SMITH -Description: penny tes t - -  Description: 210115801


What I'd like to have in cell B1 is the string of text AFTER "Naam" and BEFORE "-Description"

So, Cell B1 would show: N.D. SMITH

Is this possible? ~The number of characters before "Naam" is not constant.

many thanks for any help
Neil

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 3, 2017 at 08:32 AM
Neil, Good morning.

Try to use:

=MID(A1, FIND("Naam",A1)+6, FIND(" -Descr",A1)-(FIND("Naam",A1)+6))

Is that what you want?
I hope it helps.

Prettige dag!
--
Belo Horizonte, Brasil.
Marcílio Lobão
0