The syntax for programmatically inserting a "/" in the middle of a concatenated cell

  • Thread starter Thread starter akh2103
  • Start date Start date
A

akh2103

Hello--Does anyone know the syntax for programatically inserting a "/"
between the two added numbers of a concatenated cell? I want the value
of, say, Range("a1") to equal the value of range ("a2") "/" range
("a3"). What is the syntax for telling excel to insert the slash?
A stripped down version of my code looks like this :


Sub Concat()
Range("a1").Formula = "=Value(A2&A3)"
End Sub

I want the "/" between A2 and A3.

Does anyone know the syntax?
 
[a1] = [a2] & "/" & [a3]

Note there is a space before and after the &. Of course, you could use
the Range("A1") notation instead of [a1] if you prefer. James
 
Hey--Thanks for the help guys. The syntax you gave works for inserting
characters like 'a' in between the values, but for some reason it is
still dividing when I try to insert the /. Any ideas about what is
going on?

My code, exactly:

Sub test()

[a1] = [a11] & "/" & [a9]

End Sub
 
The code works fine for me. I cannot see how the two numbers are being
divided unless A1 begins with =. Check A1 and make sure it doesn't
begin with =. Then post back. Maybe Don has an idea. James
 
Sub insertslash()
With Range("A1")
..NumberFormat = "# ?/?"
..Value = Range("a2") & "/" & Range("b2")
End With
End Sub
 
The trouble was that the cells were in a custom format. I changed the
format to text ("@") and the problem went away. Thanks for all the
help! -Abe


Don said:
Sub insertslash()
With Range("A1")
.NumberFormat = "# ?/?"
.Value = Range("a2") & "/" & Range("b2")
End With
End Sub

--
Don Guillett
SalesAid Software
(e-mail address removed)
Hey--Thanks for the help guys. The syntax you gave works for inserting
characters like 'a' in between the values, but for some reason it is
still dividing when I try to insert the /. Any ideas about what is
going on?

My code, exactly:

Sub test()

[a1] = [a11] & "/" & [a9]

End Sub
Click to expand...
Click to expand...
 
glad to help

--
Don Guillett
SalesAid Software
(e-mail address removed)
The trouble was that the cells were in a custom format. I changed the
format to text ("@") and the problem went away. Thanks for all the
help! -Abe


Don said:
Sub insertslash()
With Range("A1")
.NumberFormat = "# ?/?"
.Value = Range("a2") & "/" & Range("b2")
End With
End Sub

--
Don Guillett
SalesAid Software
(e-mail address removed)
Hey--Thanks for the help guys. The syntax you gave works for inserting
characters like 'a' in between the values, but for some reason it is
still dividing when I try to insert the /. Any ideas about what is
going on?

My code, exactly:

Sub test()

[a1] = [a11] & "/" & [a9]

End Sub
Click to expand...
Click to expand...
Click to expand...
 
Back
Top