ExcelBanter - CELL內有文字和數字，如何只傳回數字?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - CELL內有文字和數字，如何只傳回數字? (https://www.excelbanter.com/excel-discussion-misc-queries/129233-cell%E5%85%A7%E6%9C%89%E6%96%87%E5%AD%97%E5%92%8C%E6%95%B8%E5%AD%97%EF%BC%8C%E5%A6%82%E4%BD%95%E5%8F%AA%E5%82%B3%E5%9B%9E%E6%95%B8%E5%AD%97.html)

陳先生

CELL內有文字和數字，如何只傳回數字?

All times are GMT +1. The time now is 07:24 AM.