Forum Discussion
TEXT JOIN HELP
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.
5 Replies
You'd have to change
RIGHT('124F'!J17,1)="H"
to
RIGHT('124F'!J17,2)="SL"
and similar for the other conditions.
- Nevermind lol, I closed out of it and redid that way again it DID work! THANK YOU
Good to hear that!
- I forgot to mention: I tried that also, it didnt help when I updated the CHAR to 2
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.
