Transfering information from one cell into a text cell

[chris007]

Hello once again,
Seems I am using this site a llot without contributing at this time but hopefully in the longer term I can.

If somone could please help with this delema I have

In cell $CV$4 i have txt which looks like this

Assumptions
RRR:
MFL ($):
MFL (HSE):

The delima is that I would like the numbers to be inserted by a formula if possible

I.E.
RRR: =$CS$4
MFL$) =$CU$4
MFL: HSE) =$BQ$4

Is it possible to do this?

Thank you
Regards
Chris007

 

[sijpie]

Yes - by using the &
Try a simple example in a cell:
="RRR: "&$CS$4

 

[chris007]

SIjpie,
Thanks for info, However this did not seem to do the trick. the return in CV4 is ="RRR: "&$CS$4.

did not actually take the value from CS4 and place the value after the statement of RRR:

If there is any other solution that woudl be appreciated

Regards
Chris007

 

[sijpie]

Well you must have one wierdo version of excel!


http://screencast.com/t/g8QSzLYl

 

[sijpie]

 

[chris007]

You are telling me it is weird.

It certainly looks good on your spreadsheet it is exactley what I wanted

I enterd the formula and in the cell it place the formula

i will play around with it on the weekend

I am using Office 2010 if that makes a difference

thanks
Chris007

 

[sijpie]

Make sure your cell isn't formatted as 'Text'