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

# Excel 2003 question

### #1 diggeryo Posted 18 April 2006 - 11:25 AM

diggeryo

Member

• Member
• 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

### #2 Dockboy Posted 18 April 2006 - 11:37 AM

Dockboy

Member

• Member
• 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 Posted 18 April 2006 - 11:47 AM

diggeryo

Member

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

Dockboy

Member

• Member
• 79 posts
No problemo
• 0

### #5 Retired Tech Posted 18 April 2006 - 02:52 PM

Retired Tech

Retired Staff

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

### #6 Dockboy Posted 18 April 2006 - 02:57 PM

Dockboy

Member

• Member
• 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 Posted 18 April 2006 - 03:18 PM

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
• 0

### #8 dsm Posted 23 April 2006 - 01:03 AM

dsm

Member

• Member
• 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