 |
09-07-2009, 05:29 PM
|
#1 (permalink)
|
|
06 ZX12R & 99 R1
Join Date: Jul 2007
Location: Ballajura
Posts: 3,429
|
Excel help: mixing data into a string
Hi guys,
I tried searching in Google but all I found was porn.
...anyway I need to know how to insert data into a text string.
For instance:
=??? ( "This is the text and the data is" & C14 & "the text continues")
Any help is much appreciated. Have a massive assignment I need to do and this would help out immensely
__________________
"Always out-numbered, never out-gunned"
Quote:
Originally Posted by Spuddy
I'd like to add that Robin put up a very strong fight, he almost had me, but when I had him against the wall it was all over
|
|
|
|
09-07-2009, 05:31 PM
|
#2 (permalink)
|
|
RZ's
Join Date: Feb 2004
Location: PSB Café
Posts: 13,166
|
|
|
|
09-07-2009, 05:31 PM
|
#3 (permalink)
|
|
Cell S2200 Road Bike
Join Date: Jan 2008
Location: Craigie
Posts: 2,334
|
Concatenate?
=concatenate("This is the text and the data is",C14,"the text continues")
I think...
Edit: Beaten by Nath...
|
|
|
09-07-2009, 05:31 PM
|
#4 (permalink)
|
|
Join Date: Jun 2006
Posts: 2,217
|
=CONCATENATE("text1",C14," text 2")
Hope that helps
-edit damn... blink and you are beaten.

|
|
|
09-07-2009, 08:02 PM
|
#5 (permalink)
|
|
06 ZX12R & 99 R1
Join Date: Jul 2007
Location: Ballajura
Posts: 3,429
|
Cheers all.
I've found out that you can just type:
="string here"&C43&" more text"
Been a while since I've used excel. Never heard of concatenate though but hey, if it does the same thing 
__________________
"Always out-numbered, never out-gunned"
Quote:
Originally Posted by Spuddy
I'd like to add that Robin put up a very strong fight, he almost had me, but when I had him against the wall it was all over
|
|
|
|
09-07-2009, 08:14 PM
|
#6 (permalink)
|
|
Join Date: Apr 2007
Posts: 5,840
|
^^ exactly. Don't need a function for it.
|
|
|
09-07-2009, 10:05 PM
|
#7 (permalink)
|
|
'04 GSX-R600
Join Date: Jul 2006
Location: SOR
Posts: 2,712
|
Hmmmm...
I am going to be needing some help with Excel and was wondering if the good people of PSB would be able to assist.
Will post up questions later.
__________________
Why be difficult?
Put some effort into it and be IMPOSSIBLE !
|
|
|
09-07-2009, 10:20 PM
|
#8 (permalink)
|
|
Join Date: Apr 2007
Posts: 5,840
|
Post Away. Or hit F1 first. Then Post 
|
|
|
13-07-2009, 12:27 PM
|
#9 (permalink)
|
|
'04 GSX-R600
Join Date: Jul 2006
Location: SOR
Posts: 2,712
|
F1 isn't helping 
__________________
Why be difficult?
Put some effort into it and be IMPOSSIBLE !
|
|
|
13-07-2009, 12:54 PM
|
#10 (permalink)
|
|
Join Date: Apr 2007
Posts: 5,840
|
Conditional formatting stuff still ?
|
|
|
30-07-2009, 06:04 PM
|
#11 (permalink)
|
|
'04 GSX-R600
Join Date: Jul 2006
Location: SOR
Posts: 2,712
|
No, have sorted the conditional formatting.
Can anyone that is excel -macro/vba savvy please tell me how I get a cell link from one workbook to auto update to the relevant cell in another worksheet? It is not static.
For example:
Range("B7").Select
ActiveCell.FormulaR1C1 = _
"='Q:\WOH Statistics\[VAP Claims Received.xls]2009-2010'!R[-2]C2"
Range("B7").Select
I want R[-2]C2 to change each time the macro is run. Next time I want it to be R[-1]C2, then R[0]C2. In other words I want it to move.
Yes I am not au fait with all this and would appreciate help. The whole macro works, except for this one element.
__________________
Why be difficult?
Put some effort into it and be IMPOSSIBLE !
|
|
|
30-07-2009, 06:08 PM
|
#12 (permalink)
|
|
Join Date: May 2006
Posts: 6,934
|
Keep a counter in a random cell and reference that instead?
Seems like you need some serialised data 
|
|
|
31-07-2009, 07:33 AM
|
#13 (permalink)
|
|
Blek Skittle
Join Date: Feb 2008
Location: Ina Psychiatric Ward
Posts: 214
|
Quote:
Originally Posted by Tuscadero
No, have sorted the conditional formatting.
Can anyone that is excel -macro/vba savvy please tell me how I get a cell link from one workbook to auto update to the relevant cell in another worksheet? It is not static.
For example:
Range("B7").Select
ActiveCell.FormulaR1C1 = _
"='Q:WOH Statistics[VAP Claims Received.xls]2009-2010'!R[-2]C2"
Range("B7").Select
I want R[-2]C2 to change each time the macro is run. Next time I want it to be R[-1]C2, then R[0]C2. In other words I want it to move.
Yes I am not au fait with all this and would appreciate help. The whole macro works, except for this one element.
|
Just to be clear Tuscy
You want the new set of data to be set above the latest row of data?
Matso
|
|
|
 |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Sponsors |
|
|
|