导航

在excel 中某一单元格添加指定字符的示例

Posted on 2016-01-09 21:49  高山老王  阅读(679)  评论(0)  编辑  收藏  举报

="select TestSurveyID,'http://www.findoout.cn/survey/viewsurvey.aspx?tid='+CONVERT(varchar(10),testsurveyid) as url,Title from TestSurvey with (nolock) where Title like '%"&B2&"%'"

 

B2为单元格，与通过&号与字符链接起来