Stripping out some text form a larger string [Closed]

Report
Posts
1
Registration date
Thursday February 2, 2017
Status
Member
Last seen
February 2, 2017
-
Posts
1854
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 4, 2020
-
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 reply

Posts
1854
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 4, 2020
136
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!