Stripping out some text form a larger string [Closed]

Question

Stripping out some text form a larger string [Closed]

Report

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

- 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

Stripping out some text form a larger string
Your account has been locked because we need to confirm your age. please complete the form below within 28 days to regain access ✓ - Forum - Facebook
Vim find string - How-To - Linux
Yahoo account recovery form - How-To - Yahoo mail
Usb fdd full form - How-To - USB
Unexpected t string php - How-To - PHP

1 reply

Ask a question

Mazzaropi · Answer 1 · 2017-02-03T08:32:51-0500

Answer 1 / 1

Mazzaropi

Posts: 1854
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: December 4, 2020

136
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

Stripping out some text form a larger string [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!