[µo°Ý] ¦p¦ó§â¤T­ÓÀx¦s®æ¤º®e¾ã¦X¦¨¤@­Ó¨Ã¹ï»ô

olisun

½Ð°Ý¦p¦ó§â¤T­ÓÀx¦s®æ¤º®e¾ã¦X¦¨¤@­Ó¨Ã¹ï»ô

¤U¸ü (50.71 KB)

2022-3-31 00:20

quickfixer

¦^´_ 1# olisun


    E2=IF(AND(A2<>"",B2<>"",C2<>""),(A2&REPT("  ",MAX(LEN($A$2:$A$1000))-LEN(A2)) &"+" & B2 & "  " &  REPT("  ",MAX(LEN($B$2:$B$1000))-LEN(B2)) & C2),"")
§Ú¥u·|³oºØ¤ñ¸ûªøªº°}¦C¤½¦¡(ctrl+shift+enter)

olisun

¦^´_  olisun
½Ð°Ý¦pªG¤á§O¬OS1¡A³o¼Ë­n«ç»ò³B²z?

    E2=IF(AND(A2"",B2"",C2""),(A2&REPT("  ",MAX(LEN($A$2A$1000))-LEN(A2)) &"+"  ...
quickfixer µoªí©ó 2022-3-31 01:23

¤U¸ü (82.67 KB)

2022-3-31 01:31

olisun

¦^´_ 2# quickfixer

ÁÂÁ¡A©ú¥Õ¤F

hcm19522

https://blog.xuite.net/hcm19522/twblog/590319096

­ã´£³¡ªL

D2//°}¦C¤½¦¡(¤TÁä¿é¤J)
=A2&REPT(" ",MAX(LEN(A$2:A$4))-LEN(A2))&"+"&B2&REPT(" ",MAX(LEN(B$2:B$4))-LEN(B2)+1)&C2

quickfixer

¦^´_ 3# olisun


   

¤U¸ü (14.77 KB)

2022-3-31 19:16

e2=IF(AND(A2<>"",C2<>""),(A2&REPT(" ",MAX(LEN($A$2:$A$1000))-LEN(A2)) &"+" & B2 & REPT(" ",MAX(LEN($B$2:$B$1000))-LEN(B2)+1) & C2),"")
°}¦C¤½¦¡

¥u¦b¥G¹ï»ô,¤£ºÞ¤¤¤å¦r«¬
Äæ¦ìe,·sª©excel¦r«¬¥Î   Courier New     ,ª©excel¥Î    terminal

olisun

¦^´_ 5# hcm19522


    ÁÂÁÂ

olisun

¦^´_ 6# ­ã´£³¡ªL


    ÁÂÁ«ü¾É

olisun

¦^´_ 7# quickfixer


    ½Ð°Ý¡A¦pªG¨S¦³¨®¦ì·|¥X²{+0
¨Ò¦pA1/2F¨SÁʨ®¦ì·|¥X²{A1/2F +0  §d¤jÀY¡A
«ç»ò·íµLÁʶR¨®¦ì¥X²{       A1/2F        §d¤jÀY