Hi, I would like to match 2 columns of data. both columns contain names of customers (or a transaction number) somewhere in the text in each column (start, middle or end). Basically need to match 'n' number of letters in a sequence in both columns where 'n' is a maximum number of letters.
e.g. Column A and B are data columns and Column C and D (Row Number) are the required output columns
ROW # Column A Column B Column C Column D
1 Reference 435345 John Wayne loan number 535235 customer: Jack Reacher Patrick ref 535235 John Wayne 2
2 Pack my box with Jack Reacher loan number 535245 customer: John Wayne ref 535235 Jack Reacher 1
3 Reference 435345 John Bush loan number 535235 Richard Gere ref 535235 John Bush 4
4 Richard Gere loan number 535235 customer: John Bush ref 535235 Richard Gere 3
5 Reference FT1234567899 dsfsddfs Albert Robert dfsdfs dsfdfsd FT1234567899 6
6 Albert Robert loan number 535234 FT1234567899 sdfasfsfs Albert Robert 5
Thank you in advance!
Khalid
e.g. Column A and B are data columns and Column C and D (Row Number) are the required output columns
ROW # Column A Column B Column C Column D
1 Reference 435345 John Wayne loan number 535235 customer: Jack Reacher Patrick ref 535235 John Wayne 2
2 Pack my box with Jack Reacher loan number 535245 customer: John Wayne ref 535235 Jack Reacher 1
3 Reference 435345 John Bush loan number 535235 Richard Gere ref 535235 John Bush 4
4 Richard Gere loan number 535235 customer: John Bush ref 535235 Richard Gere 3
5 Reference FT1234567899 dsfsddfs Albert Robert dfsdfs dsfdfsd FT1234567899 6
6 Albert Robert loan number 535234 FT1234567899 sdfasfsfs Albert Robert 5
Thank you in advance!
Khalid