Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding strings
sub add_strings()
A = "4=" B = CELLS(ROW,"B") 'THE CONTENT OF THE CELLS IS 2 C= A + STR$(B) END SUB The result is 4= 2 I don't want the space between the 4= & the 2 Is there a way of combining the two, but removing the leading space ?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding strings
Julian,
Try Sub add_strings() A = "4=" B = Cells(1, "B") 'THE CONTENT OF THE CELLS IS 2 C = A + Trim(Str$(B)) End Sub -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "julian brotherton" wrote in message ... sub add_strings() A = "4=" B = CELLS(ROW,"B") 'THE CONTENT OF THE CELLS IS 2 C= A + STR$(B) END SUB The result is 4= 2 I don't want the space between the 4= & the 2 Is there a way of combining the two, but removing the leading space ?? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding strings
Ctrl+H
Find = one space Replace = none entry Replace All -----Original Message----- sub add_strings() A = "4=" B = CELLS(ROW,"B") 'THE CONTENT OF THE CELLS IS 2 C= A + STR$(B) END SUB The result is 4= 2 I don't want the space between the 4= & the 2 Is there a way of combining the two, but removing the leading space ?? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding strings
Thanks. Worked fine.
Why doesn't the help file point to this simple function ?? Julian B -----Original Message----- Julian, Try Sub add_strings() A = "4=" B = Cells(1, "B") 'THE CONTENT OF THE CELLS IS 2 C = A + Trim(Str$(B)) End Sub -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "julian brotherton" wrote in message ... sub add_strings() A = "4=" B = CELLS(ROW,"B") 'THE CONTENT OF THE CELLS IS 2 C= A + STR$(B) END SUB The result is 4= 2 I don't want the space between the 4= & the 2 Is there a way of combining the two, but removing the leading space ?? . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding strings
Actually, you don't need str$. If the cell actually contains a number
(which is why you would use str$ and help does say that str$ puts a space in for the sign), you wouldn't need trim. Both Trim and Str/str$ are documented in Excel VBA help. Sub add_strings() A = "4=" B = Cells(1, "B") 'THE CONTENT OF THE CELLS IS 2 C = A & B End Sub Sub add_strings() A = "4=" B = Cells(1, "B") 'THE CONTENT OF THE CELLS IS 2 C = A & cStr(B) End Sub would work equally as well with a number in the cell. -- Regards, Tom Ogilvy "JULIAN BROTHERTON" wrote in message ... Thanks. Worked fine. Why doesn't the help file point to this simple function ?? Julian B -----Original Message----- Julian, Try Sub add_strings() A = "4=" B = Cells(1, "B") 'THE CONTENT OF THE CELLS IS 2 C = A + Trim(Str$(B)) End Sub -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "julian brotherton" wrote in message ... sub add_strings() A = "4=" B = CELLS(ROW,"B") 'THE CONTENT OF THE CELLS IS 2 C= A + STR$(B) END SUB The result is 4= 2 I don't want the space between the 4= & the 2 Is there a way of combining the two, but removing the leading space ?? . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding strings
Format$(B) will also eliminate the space.
On Tue, 7 Oct 2003 12:28:10 +0100, "Bob Phillips" wrote: Julian, Try Sub add_strings() A = "4=" B = Cells(1, "B") 'THE CONTENT OF THE CELLS IS 2 C = A + Trim(Str$(B)) End Sub |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding strings
so will just
A & B -- Regards, Tom Ogilvy "Myrna Larson" wrote in message ... Format$(B) will also eliminate the space. On Tue, 7 Oct 2003 12:28:10 +0100, "Bob Phillips" wrote: Julian, Try Sub add_strings() A = "4=" B = Cells(1, "B") 'THE CONTENT OF THE CELLS IS 2 C = A + Trim(Str$(B)) End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
Assigning strings number values and adding them together | Excel Worksheet Functions | |||
Adding strings using macros | Excel Worksheet Functions | |||
How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
How can I count strings within strings | Excel Worksheet Functions |