AutoCorrect to generate frequently used formula

This is not a "problem" I am trying to solve but more of request for feedback on something I thought up years ago and have had coworkers comment favorably on.

I have spent a good bit of time in jobs creating ad hoc reports in Excel. A trick I thought up years ago was to use AutoCorrect to generate formulas I frequently used.

Under Excel options > Proofing > AutoCorrect Options I create a few entries that all start with a tilde followed by one letter. They will AutoCorrect to a desired formula by pressing ~, letter, space leaving me with less typing to finish off a formula such as CONCATENATE or VLOOKUP nested inside an IFERROR. This auto correct trick can also be used elsewhere in MS Office.

I have posted a video on YouTube demonstrating the process.

I hope you find it informative and a good time saver. Any comments and/or suggestions ways to improve on it would be appreciated. Thanks!

Clever idea, never tried this with a formula.

If you PM me the link I will vet it and add it to your post.

There are some other built in tools to help with formula input.

Here are some links to other ideas:

https://www.excel-first.com/working-...-and-formulas/
http://dailydoseofexcel.com/archives...-intellisense/

I'd never seen auto correct being used to input formulas.

Marv

Just on a side note, and I fully understand this is just 1 instance, but I rarely use CONCATENATE to join stuff, I find & is far simpler to use.
Both of these produce the exact same result...
=CONCATENATE(A8," ",A9," ",A10)
=A8&" "&A9&" "&A10

Originally Posted by FDibbins

Just on a side note, and I fully understand this is just 1 instance, but I rarely use CONCATENATE to join stuff, I find & is far simpler to use.

I do too, but in later versions they added TEXTJOIN where you can do this:

Formula:

Please Login or Register  to view this content.

Also

Formula:

Please Login or Register  to view this content.

if you don't need them separated by a delimiter.

Thanks Jeff, Im tryin to talk myself into getting 365, but cant really justify it as, just about the only time I use excel now, is in here.

I'll move the thread to " Tips and Tutorials" if no one objects..

Originally Posted by FDibbins

Thanks Jeff, Im tryin to talk myself into getting 365, but cant really justify it as, just about the only time I use excel now, is in here.

I have 2019, which also has it. However, the only reason I got it was that I was able to get it through my client government agency HUP account for $10.

Originally Posted by 6StringJazzer

I have 2019, which also has it. However, the only reason I got it was that I was able to get it through my client government agency HUP account for $10.

Thats how I have got most of my versions so far, but I no longer work for the state. However, I am currently using an older version of W10 (1803) that is no longer being supported (and there is a bug somewhere that wont let me install the update).
With that said, I have a newer touch screen PC running a later windows (1909) that does not (yet) have office, so Im debating on transferring office 16 from here to the touch screen, and setting up the duel monitors I currently use, or just biting the bullet and getting the upgraded office for the touch screen

I shall continue to pay the £79 annual subscription to Office 365 after I retire. It covers all users in our household, and as I would class Excel as much as a grown-up toy as anything else, I don't think it's going to break the bank. It remains a no-brainer for me.

Ali which version did you get?
365 home looks pretty good, but not sure I need 6 "licences", so maybe Office 365 Personal?

It's the Home edition - covers all our devices. And of course you get OneDrive. It's great value for money, and with a daughter about to go to uni, it's perfect for us.

Originally Posted by AliGW

It's the Home edition - covers all our devices. And of course you get OneDrive. It's great value for money, and with a daughter about to go to uni, it's perfect for us.

When my kids went to university here, they both got Office for free through their schools. Of course, it expires when they graduate.

In office 365 they have download improvements to Excel. See what's new at:

https://support.office.com/en-us/art...rs=en-US&ad=US

I look at Excel as a big toolbox of math/computer tools. With each new update they add or improve another tool. I'm still learning all the old tools in Excel but find a gem to solve a problem or two each month. Just like this "AutoCorrect" being like intellisense. Power Query was a big new tool as were #Spill functions. If you have an older version you may not have these newer tools...

Originally Posted by 6StringJazzer

When my kids went to university here, they both got Office for free through their schools. Of course, it expires when they graduate.

Yes, that will be the case here, too, but honestly, for under £80 a year, it's not worth worrying about. She'll have our subscription and won't lose it when she graduates!

Originally Posted by FDibbins

Ali which version did you get?
365 home looks pretty good ...

Originally Posted by AliGW

It's the Home edition - covers all our devices ...

OK I'm going to embarrass myself.

Been reading about this version and that version for some time now and have never found indication of what version of 365 I have. Where do they hide that information? I don't find it under Info, Account, Feedback ... etc.

I think they cut that part of the ribbon off my copies ... LOL