NO FORMULAS! Concatenate First & Last Name - Detect pattern - Flash Fill: Excel!

preview_player
Показать описание
Use Flash Fill to detect patterns in your data. Excel is pretty smart! :)

Quick and easy way to concatenate values, generate reference numbers, invoice numbers etc.

----------------------------------------------------------

Flash Fill on MacBook - 

- Just use Control ^ + E

Enable Flash Fill in Windows - 

FIle-Options
Click on Advanced
Select Automatically Flash Fill check box. 

Flash Fill in Windows - 

- Go to Data and select Flash Fill 
                 OR
- Use Ctrl + E

*Flash Fill is only available in Excel 2013 and above.

------------------------------------------------------------

Check out how to display input box on click of dropdown and update cells - 

-----------------------------------------------------------

--------------------------------------------------------
Dont forget to subscribe :) 

--------------------------------------------------------

-----------------------------------------------------------
Рекомендации по теме
Комментарии
Автор

Let me know what you think about this and if you have a better solution :)

Don't forget to like, share, comment and subscribe if you want to see more videos like this! Stay Safe everyone!

idigitize