公式在excel中输入一个逗号 [英] formula to input a comma in excel

问题描述

你好，我有60个地址的联系人。例如：

$ b

  12 Chatswood Court， ROBINA 
 
 12，Chatswood Court，ROBINA 
  

我该怎么做excel没有手册，因为我花了这么长时间手动执行？

感谢您的帮助

解决方案

如果地址始终以街道号码开始，那么您可以使用

  = SUBSTITUTE A1，，，，1）
  

Hi I have here 60 contacts with address. I need to put a comma in the street number after the street name like this example:

12 Chatswood Court, ROBINA

12, Chatswood Court, ROBINA

How can I do it in excel without doing a manual because it took so long for me to do it manually ?

Thank you for the help

解决方案

If address always starts with street number then you can use

=SUBSTITUTE(A1," ",", ",1)

这篇关于公式在excel中输入一个逗号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！