Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Excel函數問題

1.如何將A1格的19701231改成B1格的591231

2.如何將A1格的02-21234567改成B1格的002及C1格的21234567

1 Answer

Rating
  • piny
    Lv 7
    1 decade ago
    Favorite Answer

    1

    B1=LEFT(A1,4)-1911&RIGHT(A1,4)

    2

    B1="0"&LEFT(A1,2)

    C1=MID(A1,FIND("-",A1)+1,999)

    如不符需求,請再詳述 ^^

Still have questions? Get your answers by asking now.