Unbrick or Recover Xiaomi Redmi 10A and other MTK devices

Case: Your Redmi 10A (probably other MTK devices too) is not turning on and doesn't react to any button pressed nor cable connection. Requisites:   Dead phone USB Cable  You tried tons of tutorials to unbrick the phone and didn't work This image Willingness to even use Linux to fix it (it's not hard) Steps: Create a bootable USB using the image downloaded. Make sure your computer allows booting from USB. Boot the computer from the bootable USB. When booting, a list of options will be shown. Pick the first one: Boot Live system. Once the system is loaded, go to the right-upper corner to connect to Wi-Fi. Once you have internet, use the Firefox browser (click on the icon in the left-upper corner) and download the Linux version of this tool (SP Flash) and save it in the desktop. Unzip the tool downloaded. Download the fastboot version of the stock ROM . Unzip the ROM, to have the folder and files. Click on 'MTK' icon that is in the desktop. In the command line opene

Replacing Enters in Excel

I had just a week ago this case, my Excel had a cell containing 4 codes separated just by enters.Excel and other Microsoft Office applications have an option to replace any kind of text, but what happen if you want to replace no-printable characters like enters.

I had just a week ago this case, my Excel had a cell containing 4 codes separated just by enters.

 
Text with line breaks in one cell
 

Then, to have this codes separate by "-" I decided to replace the enters, to do this was necessary to enter this character in the "Search" textbox, this is possible by typing "Alt + 0010" and a "." is shown flashing, after that I put the "-" which was the replacement.


Use the replace function in Excel
 
 
See the line breaks gone

Finally I got my objetive, a tip to bear in mind is that to put the enter character it's necessary to type 0010 with the numeric pad. Otherwise, nothing will happen.
 

Comments

Popular posts from this blog

Inserting Rows o Columns in Excel Not Permitted

I Need to Send an Automatic Email with Lotus Notes

Unbrick or Recover Xiaomi Redmi 10A and other MTK devices