[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

text and cell reference in cell

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
allelopath
Asked:
allelopath
  • 2
  • 2
2 Solutions
 
Rory ArchibaldCommented:
You need:
="Window="&F3
0
 
SeanStricklandCommented:
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
 
SeanStricklandCommented:
I was hoping you'd give it to rorya, but I guess he has enough points... ;)

Thanks for the grade.

Cheers,
Sean
0
 
Rory ArchibaldCommented:
I got my share. :) A split is always fair where someone adds useful info.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now