Current location - Training Enrollment Network - Mathematics courses - How to extract digits, tens, hundreds, thousands and tens of thousands in the same cell respectively, and display case in different cells (irregular cells)?
How to extract digits, tens, hundreds, thousands and tens of thousands in the same cell respectively, and display case in different cells (irregular cells)?
If the result to be returned is a number, use the following formula:

= IF((5 & gt； = COLUMN(a 1))*($ h 1 & lt； & gt"")，- MID(REPT(0，5-LEN($ h 1))& amp； $H 1, column (A 1), 1), "")

Higher than EXCEL 2003 version, you can also use this formula:

=IF($H 1= ""，" "，IFERROR( - MID(REPT(0，5-LEN($ h 1))& amp； $H 1, column (A 1), 1), ""))

Related articles
  • What do you study in every book of physics in senior high school?
  • How to find the expectation of random variable xy?
  • Is it difficult to test the primary school Olympic math coach?
  • Teaching plan of primary school mathematics preparation group (selected 5 articles)
  • What are the four basic concepts of probability theory?
  • Romantic expressions, numbers
  • Mathematical reasoning in the third grade of primary school
  • How to understand sine theorem?
  • 20 15 Hubei liberal arts college entrance examination mathematics
  • Junior high school intelligence development newspaper seventh grade people's education edition mathematics special edition answer

    • copyright 2024 Training Enrollment Network All rights reserved