- ©«¤l
- 12
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-8-12
- ³Ì«áµn¿ý
- 2016-3-16
|
subsitute©Mcharªº°ÝÃD
§Ú¦³¤@Äæ¬O
123
123
123
¨CÓ123«á±¦³´«¦æ¡AµM«á§Ú¥Îsubsituteªº¨ç¼Æ§â´«¦æªº¦r¤¸×¥¿¦¨123¡A123¡A123
§Ú¥ý¥Î¦p¤U¨ç¼Æ
=SUBSTITUTE(B3,"
","¡A")
¥i¥H¥¿½TÅã¥Ü¦¨123¡A123¡A123
¦ý¬O§Ú§ï¥Î³o²Õ¨ç¼Æ=SUBSTITUTE(B3,"char(10)","¡A")«o¨S¿ìªk
³o¬O¬°¤°»ò©O?
ÁÂÁÂÀ°¸Ñµª |
|