Skip to content

Instantly share code, notes, and snippets.

@fuchao2012
Created June 26, 2015 03:49
Show Gist options
  • Select an option

  • Save fuchao2012/f999d4fc992f143d66a8 to your computer and use it in GitHub Desktop.

Select an option

Save fuchao2012/f999d4fc992f143d66a8 to your computer and use it in GitHub Desktop.
contract string in excel
Excel 2013 单元格字符串连接需要用到「””」及「&」两个重要的符号运用,透过「””」将文字及特殊符号包起来,再用「&」串接单元格,即可进行基本的文字符串接工作。Excel 2013 单元格字符串连接需要用到「””」及「&」两个重要的符号运用,透过「””」将文字及特殊符号包起来,再用「&」串接单元格,即可进行基本的文字符串接工作。
="http://www.baidu.com"&K2&"?key=fuck";
notice:
公式里面不要出现空格
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment