Posts

Showing posts with the label Concatenate

Concatenate Text and & Operator Function

Image
Concatenate in Excel combine text columns | Excel using the #CONCATENATE function and "&" operator Combine Two or More columns in One Use of Concatenate  Join Text in Ms Excel .MIS work or daily regime especially in MNC’s / KPO / BPO where we have maximum use of #MsExcel you may have situation right where you get the raw dump or csv file from stakeholders and need to published in appropriate format or in school/ Colleges / Universities you have the list of student which are holding there first name last name or employee details with First and Last name in SQL with Join query we can easily do that however in excel Concatenate is the essential function which will help you to save your time and combine n numbers of column in one . Take look at this video and share your thoughts if any difficulty to understand ... Open for the feedback as always #ExcelFunction #TipsAndTricks  As Education is our Right so we offer this service free of cost Do subscribe us for more Learnings an

How do you concatenate cells in Excel

Image
 In this Tutorial we have covered #concatenate  ( #TextFunction , #HowToCombineText , #MsExcelTutorial  ) function which is available in ms excel.  This will save your lots of time and you will be more productive in your daily routine work .  The word concatenate is just another way of saying "to #combine" or "to join #together". We have also showed very basic step of #Text function or formula how do we leverage this in our daily routine as per our requirement complete your choice.  This whole tutorial in hindi we made it to make you understand . There may be other uses of this function but here we covered the basic thing . Text function specially ( DD, DDD, DDDD ) How it will change to the dates.  You may have queries like below then you are at the right place watch Hindi Tutorial for ms excel and be pro in your daily regime  text function in excel How to Combine Cells in Excel - Text or Numbers – Contextures How do you concatenate cells in Excel? How do you concat