TEXT JOIN HELP

[jlyas]

I'm having an issue with my TEXTJOIN writing. I have it set to write all HOLD trailers per my job: the function is to write anything with the value of "H" works PERFECT, however I want to create one similar that will write the values (trailer numbers) in the cells that have "SL" by them but when I changed it, it did NOT work. I'm noticing it will work under one character because I tried taking out the 'L" in "SL"' and it worked perfectly but when I added the additional letter, no return, any help with this would be greatly appreciated.

[#2]

@jlyas 

You'd have to change

RIGHT('124F'!J17,1)="H"

to

RIGHT('124F'!J17,2)="SL"

and similar for the other conditions.

[#3]

I forgot to mention: I tried that also, it didnt help when I updated the CHAR to 2

[#4]

@jlyas 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.

[#5]

Nevermind lol, I closed out of it and redid that way again it DID work! THANK YOU

[#6]

@jlyas 

Good to hear that!