ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦p¦ó¥Î¤£¬O¤é´Á®æ¦¡¨D©u§O(BÄæ)

¦p¦ó¥Î¤£¬O¤é´Á®æ¦¡¨D©u§O(BÄæ)

¦p¦ó¥Î¤£¬O¤é´Á®æ¦¡¨D©u§O(BÄæ)

¦p¦ó¥Î¤£¬O¤é´Á®æ¦¡¨D©u§O.zip (5.87 KB)

joyce

¦^´_ 1# leiru

B2¶ñ¤J¡A¨ä¾l¤U©Ô
  1. =LEFT(A2,3)&"Q"&ROUNDUP(RIGHT(A2,2)/3,0)
½Æ»s¥N½X

TOP

=LEFT(A2,3)&"Q"&INT(RIGHT(A2,2)/3+0.7)

OR

LEFT(A2,3)&TEXT(RIGHT(A2,2)/3+0.2,"Q0")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD