In this video, I have demonstrated to find multiple items in a single cell, like if we have list of address and wants to identify that address belongs to which city from the given list of cities.
Checkout some other Excel short trick👇
Combine Multiple Rows into One Cell👇
https://youtu.be/ldIk-7p8ygk
Extract unique items in Excel👇
https://youtu.be/vgHEKqevQNc
Convert Numbers to Roman and Roman to Numbers👇
https://youtu.be/EAzqD3qS9ZM
Insert all Pivottable Fields in Value at Once👇
https://youtu.be/PPYccnIgpzY
Subtotal and Summarize data👇
https://youtu.be/2GMwoctL0Nw
Show Hidden Data in Excel Chart👇
https://youtu.be/o09hBS1-uI4
Auto Indexing In Excel👇
https://youtu.be/4gYRVsVIBmM
Prevent Extra Spaces during Data Entry in Excel👇
https://youtu.be/XLS38WB7YtY
SUM in Blank Excel Cells👇
https://youtu.be/Wevbnt0l1VI
How to sort a pivot table with a custom list👇
https://youtu.be/Sep56kQVg_s
0 Comments