Excel Forum

Partial text matches among cells

M K

Active Member

Members

Forum Posts: 4

Member Since:
January 17, 2022

Offline

January 17, 2022 - 11:12 am

Hello,

Is there a function that can determine whether any seven (or eight or nine?) consecutive characters appearing in one cell can be found in another cell? I've tried vlookup, xmatch, xlookup, index match, and left, mid and right function (and combinations thereof). I've also tried using wildcards.

Thank you.

Mynda Treacy

Admin

Forum Posts: 4448

Member Since:
July 16, 2010

Offline

January 17, 2022 - 11:50 am

Hi M,

Welcome to our forum! I recommend you use Power Query to find partial text strings.

Hope that points you in the right direction. If you get stuck, please come back with a sample Excel file so we can see your data in context.

Mynda

M K

Active Member

Members

Forum Posts: 4

Member Since:
January 17, 2022

Offline

January 17, 2022 - 1:53 pm

Thank you. Very happy to be here. Will give it a shot.

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: RAQUEL ACION, Dana Friedt, Nada Perovic

Guest(s) 11

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

terimeri dooriyan

Jack Aston

AndyC

Denise Lloyd

michael serna

mashal sana

Tiffany Kang

Leah Gillmore

Sopi Yuniarti

LAFONSO HERNANDEZ

Forum Stats:

Groups: 3

Forums: 24

Topics: 6218

Posts: 27266

Member Stats:

Guest Posters: 49

Members: 31901

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen