CONCAT and CONCATENATE Function in Excel
hi in this video we're going to learn concat or concatenate function both of
these formulas are same in function the only difference between them is that
from 2016 version of Excel and later we have also connect at function because of
make it easier to type in shortened you can find this function in text category
of functions here and use it now alright what is the function of concat formula
then we have separate text and we want to join them together in a same cell we
can use this formula for example route 20 we have a site address that is
separated in different cells but we want to have it in same cell we use concat
function first the text is a 20 comma B 20 comma C 20 and closer now we have all
of this text in a same cell together is joined now the second situation is first
and last name we want to join them together we use can catenate also we can
use it here
8:21 T 21 and we have James Bond together
here but we also want to add a space between James and bond between first
name and last name in order to do this after first text we add quotation marks
a space quotation marks come on it's done mixed one is date bored and its
numbers
come cat a 22 come up be 22 here you see that dates board is okay but the numbers
are meaningless here actually this is the date format of Excel but it is
meaningless for us to change it to a meaningful format for us we have to use
text function inside the concat function here before B 22 that contains numbers
updates use text function the value is B 22 comma inside the inside the quotation
marks we have to the file or format for the date I use yyy stands for ear /mm
stands for bones /v dislike stands for day attention mark and close it you see
that it's dawn the most important date in the world my birthday okay now we
want to add colon and a space between date board and it's numbers here after a
22 rotations mark colon space quotations mark common it's done next one is time
we have to behave these just like tails because time is also something that it's
a it's the format is different in excel
concat a 23 come on text b23 come on
and the format of time H th e stands for our color and understands 4-minute and
after that C 23 that contains a.m. that's it now we want to add to also :
and the space call of the space station that's it the last one is time we
thought without time board we will have to add it inside the concat everyone
concat quotation mark time space now text function P 24 and formula and
format H H and M we have seconds here so you have to add SS to rotations marks
and close in order to watch more training videos please subscribe to our
YouTube channel the Apple 2e and if you want to see your products please visit
our website Yahoo dot co uk