Excel help: mixing data into a string

[Sentry]

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

[nath]

excel concatenate strings - Google Search ??

[Murley]

Concatenate?

=concatenate("This is the text and the data is",C14,"the text continues")

I think...

Edit: Beaten by Nath...

[xphread]

=CONCATENATE("text1",C14," text 2")

Hope that helps

-edit damn... blink and you are beaten.

[Sentry]

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

[TORQ]

^^ exactly. Don't need a function for it.

[Tuscadero]

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.

[TORQ]

Post Away. Or hit F1 first. Then Post

[Tuscadero]

F1 isn't helping

[TORQ]

Conditional formatting stuff still ?

[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.

[Pkunk]

Keep a counter in a random cell and reference that instead?

Seems like you need some serialised data

[Matso]

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