FInd and return next 10 characters

**param299** · 03-19-2018, 12:12 PM

can you please let me know how i can find and return the next 10 characters.
For Example:
I Have below text in a cell and i want to Find BUDAT and return 03/25/2011.
0125BKPF-BLDAT03/25/2011BKPF-BLARTR2BKPF-BUKRSA000BKPF-BUDAT03/25/2011BKPF-WAERSUSDBKPF-XBLNR142399-52500BKPF-BKTXTLeg.WB Pmt-PID 506399BKDF-DBATR03/25/2012BKDF-BELNR91000190

THanks.

**JohnTopley** · 03-19-2018, 12:17 PM

Try

=MID($A1,FIND("BUDAT",$A1)+5,10)

Data in A1

**6StringJazzer** · 03-19-2018, 12:17 PM

If your data is in A1, and "BUDAT" is in B1:

Formula:

Please Login or Register  to view this content.

**Glenn Kennedy** · 03-19-2018, 12:19 PM

If it's a date... then maybe you should just add two - to it, and format as da date.

=--MID($A1,FIND("BUDAT",$A1)+5,10)

**param299** · 03-19-2018, 12:35 PM

THanks JOHN, GLEN and 6stringjazzer for your help.

FInd and return next 10 characters

LinkBack

Thread Tools

Rate This Thread

Display

FInd and return next 10 characters

Re: FInd and return next 10 characters

Re: FInd and return next 10 characters

Re: FInd and return next 10 characters

Re: FInd and return next 10 characters

Thread Information

Users Browsing this Thread

Similar Threads

Find characters in a cell containing characters and numbers

Excel Use Word to Find Text and return the following 10 characters

[SOLVED] Find the last dot in an entry and return the characters after it

[SOLVED] Return part of text between 2 different characters ALSO after 2 of the same characters

return 4 characters usign find

[SOLVED] In Excel find characters when multiple characters exist w/i a cel

[SOLVED] [SOLVED] Find/Replace carriage return & line feed characters in Excel.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

FInd and return next 10 characters

Re: FInd and return next 10 characters

Re: FInd and return next 10 characters

Re: FInd and return next 10 characters

Re: FInd and return next 10 characters

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find the last dot in an entry and return the characters after it

[SOLVED] Return part of text between 2 different characters ALSO after 2 of the same characters

[SOLVED] In Excel find characters when multiple characters exist w/i a cel

[SOLVED] [SOLVED] Find/Replace carriage return &amp; line feed characters in Excel.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

[SOLVED] [SOLVED] Find/Replace carriage return & line feed characters in Excel.