Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel 2003 question


  • Please log in to reply

#1
diggeryo

diggeryo

    Member

  • Member
  • PipPipPip
  • 343 posts
Is it possible to put text and a formula into the same cell? My mind reverted back to my old Pascal ways and I tried commas and apostrophes, but can't seem to get it to work.

Any help is appreciated.

thanks,
mike.
  • 0

Advertisements


#2
Dockboy

Dockboy

    Member

  • Member
  • PipPip
  • 79 posts
Hi Mike,

Sorry to tell you that no it is not. If you put a formula into a cell, it can be the only thing in that cell. Any words that you put in front on the start of the function or at the end of the function will null the function, and you will end up with something like "Dockboy=SUM(A4+B4)" showing in the cell. But you probably already know that. You will have to resort to the words being in the cell beside the formula cell. Just how it works. Sorry.

Cheers:)
  • 0

#3
diggeryo

diggeryo

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 343 posts
I figured as much, since I couldn't find help on it anywhere. Thanks for the quick heads up.
  • 0

#4
Dockboy

Dockboy

    Member

  • Member
  • PipPip
  • 79 posts
No problemo :whistling:
  • 0

#5
Retired Tech

Retired Tech

    Retired Staff

  • Retired Staff
  • 20,563 posts
Can you put an example of what you want in one cell
  • 0

#6
Dockboy

Dockboy

    Member

  • Member
  • PipPip
  • 79 posts
Keith,

Although your solution is a correct answer, it was not what he was looking to do. He wanted to have text and a formula within one cell.

I do not mean any disrespect to you in any way, I just thought I should point out what he was asking, in case you had interpreted it wrong.

All the best

Cheers:)



*I see you just changed your post when I posted my response. No worries then. Cheers:)

Edited by Dockboy, 18 April 2006 - 02:58 PM.

  • 0

#7
Retired Tech

Retired Tech

    Retired Staff

  • Retired Staff
  • 20,563 posts
I just wondered if using shrink to fit or enlarging the cells was it, then decided it couldn't be that easy, so changed the response I was probably changing it while you were posting yours :whistling:
  • 0

#8
dsm

dsm

    Member

  • Member
  • PipPip
  • 98 posts
Mike,
I was a bit confused by the trail of responses and exactly what you wanted to do. It is definitely possible to combine text and formula in a cell as in the following example.

="Dockboy " & SUM(A4:B4)

HTH
David
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP