|
发表于 2012-2-4 01:57
|
显示全部楼层
本楼为最佳答案
本帖最后由 happym8888 于 2012-2-4 02:01 编辑
根据楼主6楼补充的图纸,我估猜你的意思是10~100+n里面的n要加到100里去,如果n是10,就是单元格要变成10~110,那么如果用工作表函数,应该是这样:
=LEFT(B26,FIND("~",B26,1))& LEFT(RIGHT(B26,LEN(B26)-FIND("~",B26,1)),FIND("+",RIGHT(B26,LEN(B26)-FIND("~",B26,1)),1)-1)+RIGHT(B26,LEN(B26)-FIND("+",B26,1))
另外,建议楼主改用VBA代码解决,比较方便。方法是在工具栏上添加个图标(这个要你自己在你的电脑上操作),选中拟转换的单元格,单击图标、激活转换VBA代码,代码我帮你编好如下:
- Sub huansuan()
- Dim x As String, Qw As Integer, Qe As Integer, QianMian As String, QianMian1 As String
- Dim HouMian As String, HouMian1 As Integer
- On Error GoTo 100
- x = Selection.Value
- Qw = InStr(x, "~")
- Qe = InStr(x, "+")
- QianMian = Left(x, InStr(x, "~"))
- HouMian = Right(x, Len(x) - Qw)
- QianMian1 = Left(HouMian, InStr(HouMian, "+") - 1)
- HouMian1 = Right(HouMian, Len(HouMian) - InStr(HouMian, "+"))
- Selection.Value = QianMian & (Val(QianMian1) + Val(HouMian1))
- 100:
- End Sub
复制代码 以上代码是一个一个单元格转换的,如您需要批量转换(选中拟转换区域),我另外再帮你改代码。附件如下:
shcs_auto.rar
(14.25 KB, 下载次数: 7)
|
|