一、首先，打开excel表格程序，在程序中打开要去除文字保留文字的表格。
/iknow-pic.cdn.bcebos.com/b7003af33a87e9508f33500b1e385343fbf2b4b5"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b7003af33a87e9508f33500b1e385343fbf2b4b5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/b7003af33a87e9508f33500b1e385343fbf2b4b5"/>
二、然后，在点击“开始”在开始菜单中点击“智能工具箱”，点击打开。
/iknow-pic.cdn.bcebos.com/3812b31bb051f819e129a02dd4b44aed2e73e74d"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/3812b31bb051f819e129a02dd4b44aed2e73e74d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/3812b31bb051f819e129a02dd4b44aed2e73e74d"/>
三、然后，选中要去除文字保留数字的单元格区域。
/iknow-pic.cdn.bcebos.com/d62a6059252dd42a862ea2cc0d3b5bb5c9eab8b6"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d62a6059252dd42a862ea2cc0d3b5bb5c9eab8b6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/d62a6059252dd42a862ea2cc0d3b5bb5c9eab8b6"/>
四、然后，在上方的“工具栏”中点击单元格处理，在下拉菜单中选择“保留内容”，点击打开。
/iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd9581997be3701213fb80e91a5"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd9581997be3701213fb80e91a5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd9581997be3701213fb80e91a5"/>
五、然后，在弹出的对话框中勾选“数字”，点击确定保存设置。
/iknow-pic.cdn.bcebos.com/dbb44aed2e738bd4de161156af8b87d6277ff9a6"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/dbb44aed2e738bd4de161156af8b87d6277ff9a6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/dbb44aed2e738bd4de161156af8b87d6277ff9a6"/>
六、最后，即可看到Excel表格中取出文字保留数字完成，问题解决。
/iknow-pic.cdn.bcebos.com/e850352ac65c1038eda26ea5bc119313b17e89fd"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/e850352ac65c1038eda26ea5bc119313b17e89fd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/e850352ac65c1038eda26ea5bc119313b17e89fd"/>