Solved

text and cell reference in cell

Posted on 2011-03-15
4
235 Views
Last Modified: 2012-05-11
I have a cell that is not quite right:
window=F3
I want the text "window=" but then the value of cell F3 after it.
As it is, I get "window=F3"
0
Comment
Question by:allelopath
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 400 total points
ID: 35138481
You need:
="Window="&F3
0
 
LVL 11

Assisted Solution

by:SeanStrickland
SeanStrickland earned 100 total points
ID: 35138550
Give the points to rorya, but there's also a CONCATENATE function that some of my users prefer (because the quotes and & signs confuse them).

=CONCATENATE("window=",F3)
0
 
LVL 11

Expert Comment

by:SeanStrickland
ID: 35139970
I was hoping you'd give it to rorya, but I guess he has enough points... ;)

Thanks for the grade.

Cheers,
Sean
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35139990
I got my share. :) A split is always fair where someone adds useful info.
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question