如果STR = "1856_ "則CELLID = Right(ColNumber,5)
其他
CELLID = ColNumber
如果…就會結束
只需將CELLID = Right(ColNumber,5)放在其後:
如果STR = "1856_ "那麽
CELLID = Right(ColNumber,5)