Text Functions you need to know in Excel

This video covers how to join and split text cells in excel, these can be useful for data analysis and report building. Depending on what task is at hand, you now have seven options to split or combine text to find your desired result.

The text functions covered in this video are as follows :

=LEFT() -- LEFT returns the first character or characters in a text string, based on the number of characters you specify.

=RIGHT() -- RIGHT returns the last characters in a text string, based on the number of characters you specify.

=TEXTAFTER() -- Returns text that occurs after given character or string.

=TEXTBEFORE() -- Returns text that occurs before a given character or string.

=TEXTSPLIT() -- The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows.

=CONCAT() -- The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments.

=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.
--------------------------------------------------------------------------------------------------------------------
Check out my TikTok Channel for short length content.
https://www.tiktok.com/@excelhelps1

Check out my Webpage for Practice datasets in Excel and resources for learning how to code!
https://excelhelps.github.io/ExcelHelps/

Check out my Etsy shop for Premade Financial Spreadsheet templates to save yourself time.
https://www.etsy.com/shop/ExcelHelps/

Check out my channel for more help with Excel, Word, PowerPoint, Clipchamp, Coding / SQL, and other topics!

Like, Subscribe, and Comment if you have any questions!

Thanks for Watching!

#excel #exceltutorials #excelfunctions #learn #data #dataanalysis #spreadsheet #finance #subscribe

Тэги:

#Text_functions_in_Excel #Excel_tutorials #Learn_text_functions_in_excel #How_to_split_cells_in_Excel #How_to_combine_cells_in_Excel #how_to_concatenate #learn_to_combine_text_cells_in_excel #Excel_tutorials_for_data_analysis #How_to_split_text_in_Excel #Data_analysis_using_microsoft_excel #Join_text_in_Excel #Learn_microsoft_Excel #Tutorials_for_data_analysis #Learn_Excel_on_YouTube #Learn_Excel_on_TikTok #Text_Function #Text_Functions_in_Excel #Text_functions_you_need_to_know

Скачать видео