Here is what I would like to do. Just started researching this but I know there are some pretty smart folks on here who might already know it, so here goes.
Take the last word from string C2 and add it to the beginning of string E2 followed by a space (" "), IF the total number of combined characters does not exceed 24 in length.
ie.
C2 = "AM 63/37 032 P3 Telecore+"
E2 = "5lb SO"
Combined string would read "Telecore+ 5lb SO" since total length is <=24 characters.
Or
C2 = "AM 63/37 032 P3 Telecore+"
E2= "5lb SO; 4000/RL 10RL/CA"
No string would place because the combined string would exceed 24 characters.
Hope that is clear. Thanks for any help and advice.
Bookmarks