Excel में Text कैसे जोड़ें Concatenate, &, Concat, TextJoin
HTML-код
- Опубликовано: 6 дек 2018
- 👉 FREE Excel Webinar. REGISTER NOW
event.webinarjam.com/register...
We can join text using Concatenate, &, Concat and TextJoin function in Excel. Although CONCAT and TEXTJOIN functions are available only in Office 2016, 2019 & Office 365 versions.
Download the excel file here: learn-with-lokesh-lalwani.thi...
Let's have a look at the syntax and arguments of the functions:
CONCATENATE:
Use CONCATENATE, one of the text functions, to join two or more text strings into one string.
Syntax: CONCATENATE(text1, [text2], ...)
text1 (required)
The first item to join. The item can be a text value, number, or cell reference.
Text2, ... (optional)
Additional text items to join. You can have up to 255 items, up to a total of 8,192 characters.
CONCAT:
This function replaces the CONCATENATE function. However, the CONCATENATE function will stay available for compatibility with earlier versions of Excel.
The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
Syntax: CONCAT(text1, [text2],…)
text1
(required)
Text item to be joined. A string, or array of strings, such as a range of cells.
[text2, ...]
(optional)
Additional text items to be joined. There can be a maximum of 253 text arguments for the text items. Each can be a string, or array of strings, such as a range of cells.
TEXTJOIN:
The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
Syntax: TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
delimiter
(required)
A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. If a number is supplied, it will be treated as text.
ignore_empty
(required)
If TRUE, ignores empty cells.
text1
(required)
Text item to be joined. A text string, or array of strings, such as a range of cells.
[text2, ...]
(optional)
Additional text items to be joined. There can be a maximum of 252 text arguments for the text items, including text1. Each can be a text string, or array of strings, such as a range of cells.
For more such videos subscribe to our channel: / @learnwithlokeshlalwani
Follow me on Instagram: learnwithlo...
Learn Excel from my in-depth course: hi.switchy.io/ExcelMasterclass 🔥🔥
Assalamualakum sir please data analyst ke mutaaliq koyiii complete vedio upload karo aapkiiii maharbaani hogiiii love you from pakistan
ruclips.net/video/d90O3iZir0g/видео.htmlsi=s6d9hvUqT9rKzeLm
Thank you ☺️
THANKYOU
Very Useful where Flash Fill Limit starts, thesse functions' working start....Thanks for your update
ruclips.net/video/d90O3iZir0g/видео.htmlsi=s6d9hvUqT9rKzeLm
thanks sir
Sir you are great for practice examples
ruclips.net/video/d90O3iZir0g/видео.htmlsi=s6d9hvUqT9rKzeLm
thank u sir for the video.
can u please upload a video regarding my problem..
I have table in excel.
1-if I give a value in a cell , can excel find that value in the table for me .
2-next I want excel to select the value in the left most cell of the same row, where the given value in table was found.
3-next the value which is selected in 2nd step ,is added to the value found at the top of column of the cell selected in first step.
in short if a give a value in a cell, excel find out that value in table, then the corresponding value at the left most in the row is added to the value corresponding to the value at the top of the column.
thank u..
very nice keep informing us thank 🙏👍😊
ruclips.net/video/d90O3iZir0g/видео.htmlsi=s6d9hvUqT9rKzeLm
Sir I am from pakistan. First I say thanks to you for your golden work....kindly make a complete playlist of excel course from beginning to advance level and cover each and every part, functions, and all aspects of excel...also share some videos about how to manage a mega data in excel like inventory of store, employee id salaries....I also want to say you about how to compare different data of various sheets....you are amazing sir❤
Please follow these link, here you will be able to watch videos with excel functions: ruclips.net/p/PLO4FdoOX3oRWc0ZF37_Qmdv1Kr-zPxWXn
ruclips.net/p/PLO4FdoOX3oRXCPwFMf-oJDNcWpEJQGCzk
I will suggest that you join my free webinar. Here all your doubts will be cleared. Here is the link to register: event.webinarjam.com/register/13/m4851s2
ruclips.net/video/d90O3iZir0g/видео.htmlsi=s6d9hvUqT9rKzeLm
Sir, I want this function to be applied on a separate or Multiple sheets (that sheet should be called a separate file). It happens. But I want I don't have to apply this function again and again inside each block, it should be applied automatically in all other blocks, please guide.
Very useful video. 👌
ruclips.net/video/d90O3iZir0g/видео.htmlsi=s6d9hvUqT9rKzeLm
Good Video. But, we need to write name in the Address area, and the First name and Last name should not have "comma" between them but should have a space followed by other part of Address with "comma and space". Can this task be achived without joining them in a separate cell which shall be placed after Last name. Same is the problem if we want add Salutation - Mr., Mrs., etc.
Very helpful👍
ruclips.net/video/d90O3iZir0g/видео.htmlsi=s6d9hvUqT9rKzeLm
Super 👌
Thank you
Thanks sir
ruclips.net/video/d90O3iZir0g/видео.htmlsi=s6d9hvUqT9rKzeLm
really needed video
Thank you so much for your comment.
ruclips.net/video/d90O3iZir0g/видео.htmlsi=s6d9hvUqT9rKzeLm
but sir it didn't take space after comma!
Nice
ruclips.net/video/d90O3iZir0g/видео.htmlsi=s6d9hvUqT9rKzeLm
Guruji me select karke enter press karti hoon to bo hota nahi.please help me.error dikhata hai.
Sir concatenate formula ma enter krne pr join nhi ho rha h! Bs formula likha aa rha h
Kisi data ko column se row aur row se column kaise kare jab data bada ho
ruclips.net/video/d90O3iZir0g/видео.htmlsi=s6d9hvUqT9rKzeLm
hello Sir,
I am also trying to join the date but excel is converting the date into number and i want that date as it is. Can you help me on this. How can I do that?
ruclips.net/video/d90O3iZir0g/видео.htmlsi=s6d9hvUqT9rKzeLm
ढाई घंटा एक्सेल में काम किया समझ नही आ रहा था की में क्या गलती कर रहा था , 20मिनट आपके वीडियो देख समाज आया की में old version excel use कर रहा था,उसमे concatenate function था पर concat function नहीं था
$22345564.55 & and & $45567345.56
2 cell mein he ager isko concatenate korne ke bad $ sighn nehi aha rehi hein.. pls solve it