Sign in to join the conversation:
Hi, i need to join 2 columns. First column is the City Name and second is the Numbers. I got it to work but I only need the first 3 digits from the City : =JOIN(City1 + Number1) comes out CITYNAME3462
I need to show up CIT3462
thank you for the help
Try
=Left(City1, 3) + Number1
OR if your join actually worked, you can also try this...
=Join(Left(City1, 3) + Number1)
Thank you very much!
A colleague of mine and I used to use the row menu "send" option with years of success. It would email the row data to an email address of our choosing, but it no longer works. A couple of new interns we hired use the option with 100% success. I have tried all of the solutions found online and have not found a solution.…
Is there an option a sheet that forces a person to complete the information in the cell? or will not let the person go the next cell without completing the one before?
is it possible when adding photos in the attachments for a row, can the image be a photo scanner capability? we have equipment that has bar codes on the boxes, instead of taking photos, is there an option for a bar code scanner and upload the information from the bar code ? or another example - like a VIN tag inside a…
