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...
Hi,
The problem in the desired format is not consistent.
But you can use this formula to get as much similarity as possible:
=REPLACE(REPLACE(REPLACE(B2,4,0," "),8,0," "),12,0," ")
Also, you can use the MATCH function on top of it to get the row number of the matched cell in the desired format column:
=MATCH(REPLACE(REPLACE(REPLACE(B2,4,0," "),8,0," "),12,0," "),A:A,0)
Hope that helps