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

[µo°Ý] ¦p¦ó§Q¥Î¨ç¼Æ¦Û°Ê°µ¸ê®Æ­åªR

B3
=IF(COLUMN(A1)<5,TRIM(INDEX(MID('Raw data'!$A3,{1,18,26,51},{15,8,25,30}),COLUMN(A1))),TRIM(MID(SUBSTITUTE(TRIM(MID('Raw data'!$A3,90,999))," ",REPT(" ",99)),(COLUMN(A1)-5)*99+1,99)))

¥k©Ô¤U©Ô
³£¬O¤å¦r®æ¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# williampeng

¤½¦¡¤À¬°2¬q¨Ó¬Ý¤ñ¸û®e©ö¡A
«e4­Ó±Ä¥Î©T©w¦ì¸m¨ú¥X¡A«á­±¥HªÅ®æ(³sÄòªÅ®æµø¬°1­Ó)»á¶}¨ú¥X
=IF(COLUMN(A1)<5,
TRIM(INDEX(MID('Raw data'!$A3,{1,18,26,51},{15,8,25,30}),COLUMN(A1))),
TRIM(MID(SUBSTITUTE(TRIM(MID('Raw data'!$A3,90,999))," ",REPT(" ",99)),(COLUMN(A1)-5)*99+1,99))
)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD