- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
Excel assistant software functions
Data transformation tools
Convert to uppercase
Convert to lowercase
Text inversion
Delete starting blank
Delete all blank spaces
Convert data to text
Convert data into numerical values
Set the precision to the displayed precision
Convert the numerical value to uppercase amount
Ranking of values
together.
be blurred
Data comparison tool
ID card tool
Obtain place of birth based on ID card number
Get gender based on ID number
Get birthday based on ID number
Get age based on ID number
Verify the correctness of ID card
The 15-digit ID number has been upgraded to 18 digits
Encryption and decryption tools
Clear worksheet password
Clear workbook password
Encrypt cell data
Decrypt cell data
File tools
Convert file path to link
Generate file list (get file name)
Create folders in batches
Import Word documents into the current workbook
Import pictures in batches
Copy the selected area to a picture
Save the selected area to an image file
Save the selected graphic image to a file
Save the current worksheet to a file
Convert file formats in batches
Create Word documents in batches
Batch generation of sticker cards
Highlighting tool
Reading mode (spotlight)
Mark the same value in real time
Mark cells with the same value in the selected area
Mark cells with different values in the selected area
Mark the cells with the same value in the selected two rows
Mark the cells with different values in the selected two rows
Mark cells with the same value in two selected columns
Mark cells with different values in the selected two columns
Merge tools
Vertically merge cells with the same value
Merge adjacent blank cells vertically
Undo merged cells and fill in data
Consolidation and totaling (left → right)
Merge the same cells on the left and merge the values of the cells on the right at the same time
Consolidation and totaling (right → left)
Random Tools
Fill in random names
Fill in the random mobile phone number
Fill in the random ID number
Randomly change the data order of selected rows
Randomly transform the data order of selected columns
Randomly transform the data order of selected cells
Randomly select data
Randomly fill in values
Randomly filled text
Financial Tools
Making up the numbers (Solver)
Adding titles in batches (header)
Data grouping and splitting
Student performance tools
Score ranking
Score statistical analysis
Excel Assistant update log:
Sweep the bug out and carry it out to the end
Optimize user feedback issues and improve detailed experience
Huajun editor recommends:
Excel Assistant has always been a commonly used office software for most netizens. Its dominance in the minds of netizens is obvious. It is strongly recommended that users download and use Excel Assistant. Come to Huajun Software Park to download it. In addition, there areToday's goal,Hanwang Attendance Management System,Aimo mind map,NTKO large file upload control,Kuai Dao Ke platform softwareAvailable for download.
Your comment needs to be reviewed before it can be displayed