I don't understand where you got the idea that LOWER takes a second parameter to specify length.
Reading the documentation I don't see it, so it's strange that your whatever site fails to notify you of an invalid formula...
I read it at just taking the first 3 letters and showing them in lowercase, which is trivial such as:
=LOWER(LEFT($A1,3))
Then if you mean you should show the first 3 letters in lowercase and then the rest of the characters in whatever upper/lower combination they have, I guess something like...
What are you even asking for help with?
If you don't understand how to complete Task 2, then maybe it would be a good start to show the actual formula you need to change.
It should also be rather trivial to lookup the individual parts of the task, so what exactly are you finding so difficult?
Just wanted to mention that after much headache the issue ended up being the BIOS from Sapphire. So it appears as my RX 5600 XT is stable now.
Apparently my BIOS was outdated even after flashing it when I received the card, not clear on how that is possible, nor do I fully understand the...
I appreciate the suggestion, I haven't really considered that my drivers would get corrupt/have issues, from changing a GPU that uses the same drivers.
A clean install of everything is a rather major task for me, definitely something I will try and wait a little while with until AMD comes back...
Thank you very much!
Well, that's all fine by me, I would personally find it a bit suspicious as well, though anyone who follows this issue/ had these issues would know what a pain it's to deal with.
I am on Windows 10, if you mean when the OS was installed it has been years, and it's been...
Can't imagine how the drivers were before this.
Recently picked up an RX 5600 XT, and the amount of crashes, system freezes, drivers stops responding, drivers don't launch properly forcing reboots, it's staggeringly bad. This with the 20.2.2 drivers.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.