Forum Discussion
Help with application of text string formulas
Hi, Can anyone help me with a formula to adjust the partnumbers in the 2nd column to the format in the 1st column? I've used text to column and some text string formulas on the 2nd column but I'm no...
If your goal is only to match between the two columns, you can make the Desired Format as the Old format in a helper column using this formula:
=SUBSTITUTE(A2," ","")
Then use the MATCH function on the new column.
This is will reduce the unmatched cells.
Please find this in the attached file.
Hope that helps