- Видео 2
- Просмотров 11 446
Daily Tech Tips with Jason Ishibashi
США
Добавлен 23 май 2022
Three Ways to Join Text in Excel
Three ways to join text together in Microsoft Excel:
1. the Join operator (&)
2. the CONCAT function
3. the TEXTJOIN function
Some of the functions used in this video:
=B2&" / "&D2&" / "&F2&" / "&H2&" / "&J2
=CONCAT(B2," / ",D2," / ",F2," / ",H2," / ",J2)
=TEXTJOIN(" / ",TRUE,B2,D2,F2,H2,J2)
=TEXTJOIN(", ",TRUE,M2:Q2)
1. the Join operator (&)
2. the CONCAT function
3. the TEXTJOIN function
Some of the functions used in this video:
=B2&" / "&D2&" / "&F2&" / "&H2&" / "&J2
=CONCAT(B2," / ",D2," / ",F2," / ",H2," / ",J2)
=TEXTJOIN(" / ",TRUE,B2,D2,F2,H2,J2)
=TEXTJOIN(", ",TRUE,M2:Q2)
Просмотров: 25
Видео
Mail Merging Barcodes & QR Codes
Просмотров 11 тыс.2 года назад
How to mail merge barcodes & QR codes from an Excel workbook into Word and why you might want to do this.
you saved my day
Thank you for the video. It might be helpful if you could zoom in on some of the text entries during the Mergebarcode process. On my computer, it looks like there are random dots in between words. Perhaps an optical illusion of sorts.
INACREDITAVEL !! VERY THAKSSSS
You know this doesn't work for MS word on a mac right?
Hi Jason! I'd like to pass a vcard from Excel through to MS-Word and display a QR code, but it appears that using your technique, MS-Word smashed everything into a single line, which then cannot be interpreted as a vcard (because vcard relies on CRLF to separate fields). Do you have a solution?
Great tutorial. Can you create a vCard - QR Code with the merge as well?
I'm working on this exact problem and it appears not doable or at least not obvious. vCards have to have multiple lines and when the mergebarcode field gets multiple line input, it converts them to a single line (ignores the CRLF) making the QR code unreadable. If you found a solution, I'd be interested to know.
THANK YOU BRO!!!
Hello, I really appreciate your presentation. Kindly try magnify your screen. Can't see clearly
huhuhuhuhu thank you thank you very much <3
Can you add a return or tab from excel or word built into the QR code?
Really useful! Using it for generating Google form links QR codes for prefilled data.
THIS! Thank you
Very Useful Bro👍