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

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

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

¥»©«³Ì«á¥Ñ olisun ©ó 2022-3-31 00:21 ½s¿è

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

BOOK1.rar (8.53 KB)

¦^´_ 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)

TOP

¦^´_  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

TOP

¦^´_ 2# quickfixer

ÁÂÁ¡A©ú¥Õ¤F

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

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

TOP

¦^´_ 3# olisun


   

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

TOP

¦^´_ 5# hcm19522


    ÁÂÁÂ

TOP

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


    ÁÂÁ«ü¾É

TOP

¦^´_ 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

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD