Forum Discussion
Display Text Based On Text In Another Column
My fault, I missed that your first post did not have the trailing numbers. It appears that you want the characters to the left of the first number that appears in the trailer number?
I believe you will still need a lookup table to crosswalk the codes and the places, but I modified the formula to find the first numeric character in the trailer number, if any, and pull the characters to the left of that.
Is the attached workbook what you are trying to do? Note the formula generally will require you to hit Ctrl+Shift+Enter after keying it in (I don't know if the latest office 365 would as I don't have that version).
Its close to what I need. Sorry I didn't exactly explain it correctly now that I look at it.
The reason I wanted a letter detection is because the trailers could range from FF1 - FF22 or could have a letter FF1a, RS1a etc which is why I was wondering if there would be a formula to detect just the first couple letters of the trailers?
Hopefully this makes sense
My fault, I missed that your first post did not have the trailing numbers. It appears that you want the characters to the left of the first number that appears in the trailer number?
I believe you will still need a lookup table to crosswalk the codes and the places, but I modified the formula to find the first numeric character in the trailer number, if any, and pull the characters to the left of that.
Is the attached workbook what you are trying to do? Note the formula generally will require you to hit Ctrl+Shift+Enter after keying it in (I don't know if the latest office 365 would as I don't have that version).