They were added to Excel 2019. ... Apparently the spaces were removed when I posted it, I'll use _ to make it easier to visualize ______42345566G Austin Texas I want to only output 42345566G, when using substitute and lens I got ______42345566G Austin , and when using left trim I outputted 42345566G Austin Texas. Is there any way for me to only output 42345566G and remove the spaces before it using LEFT and TRIM functions... More on mrexcel.com

Is there a way to use TRIM/LEFT/RIGHT/LEN with an Excel textstring to remove the Nth character after the Nth occurrence of a numeric value? As an example, I would like to have a function that would trim strings 9U100 and GF3C06 after the 1st occurrence of a numeric value at the 3rd character ... More on techcommunity.microsoft.com

Okay, so there's probably a better solution, but I don't know it. A hacky solution that should work however, is as follows: Create a lookup table with all the numbers / special characters Add columns before your values equal to the length of the lookup table + 2 Put this formula in the first row =TRANSPOSE(IFERROR(FIND(;);"")) The leftmost column will show the location of a 0 if it finds a 0 (or whatever you put at the top of the lookup table), the second column will do the same for a 1, etc. This should net you a bunch of empty cells, and per row a single cell with the index of the lookup value. Then in the first of the two extra columns, use a simple MAX() over the spilled columns we just generated to find the relevant index value. Finally, in your last empty column, use =LEFT(; ). Hope this helps! More on reddit.com

You want to save money, and your first impulse is not to start saving money, but to spend money on classes? I think you need to interrogate that, as it's probably part of your problem. There are some great resources in r/personalfinance . I would check out the wiki and the reading list. If you see a book you like, get it from the library. Based on the rest of the your post, I would also recommend a few things you can start doing now. Figure out where all of your money is going. Log every single purchase. Yeah, there's software that can do this, but part of the value in this exercise is to make you pause and see exactly what you're doing. Every time you grab a coffee or go to a restaurant or "treat yourself," write it down or take a picture of the item and the receipt and write it down later. After a week or a month, look at this log and ask yourself, are you okay with this? Do you still remember and think fondly of and stand by these purchases? Is there something else you would rather have done with the money? Consider a "pay yourself first" setup where shortly after your paycheck hits, the money that's your savings goal automatically comes out of your checking and goes to a high yield savings account at a different bank where you won't see it in your account. Maybe it will feel less like it's burning a hole in your pocket. Find cheaper and free things to go out and do. If you take classes, is there a cheaper equivalent (community center, library, local community college or university extension; or does your library offer coursera or edex?)? If you like writing, can you just journal yourself for free or find a writing buddy? If you would go out to eat with friends can you organize a potluck or picnic? Cooking together? What about volunteering with your friends or to meet people? You don't have to spend a lot of money to do things. Think about your goals for this money. Is this an emergency fund? Are you saving for something specific? Knowing what it's for can be motivating. More on reddit.com