Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The syntax for programmatically inserting a "/" in the middle of a concatenated cell
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
The syntax for programmatically inserting a "/" in the middle of a concatenated cell
Sub insertslash()
Range("a1") = Range("a2") & "/" & Range("b2") End Sub -- Don Guillett SalesAid Software wrote in message ps.com... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
The syntax for programmatically inserting a "/" in the middle of a concatenated cell
[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 wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
The syntax for programmatically inserting a "/" in the middle of a concatenated cell
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
The syntax for programmatically inserting a "/" in the middle of a concatenated cell
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 wrote: 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
The syntax for programmatically inserting a "/" in the middle of a concatenated cell
Sub insertslash()
With Range("A1") ..NumberFormat = "# ?/?" ..Value = Range("a2") & "/" & Range("b2") End With End Sub -- Don Guillett SalesAid Software wrote in message oups.com... 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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
The syntax for programmatically inserting a "/" in the middle of a concatenated cell
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 Guillett wrote: Sub insertslash() With Range("A1") .NumberFormat = "# ?/?" .Value = Range("a2") & "/" & Range("b2") End With End Sub -- Don Guillett SalesAid Software wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
whyis "paste spl" copying concatenated cell changing lastdigit2 0 | Excel Worksheet Functions | |||
inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions |