Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can you have a formula followed by text all in one cell?
Just as the subject askes, I what to have a formula in a cell that the number
that it puts out is then followed by whatever text i want. Is this possible? |
#2
|
|||
|
|||
Hi Brian,
=A1+B1&" Is the result of adding A1 & B1" -- Kind regards, Niek Otten "Brian" wrote in message ... Just as the subject askes, I what to have a formula in a cell that the number that it puts out is then followed by whatever text i want. Is this possible? |
#3
|
|||
|
|||
Brian, here is on way,
=A1&" Your text here" -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Brian" wrote in message ... Just as the subject askes, I what to have a formula in a cell that the number that it puts out is then followed by whatever text i want. Is this possible? |
#4
|
|||
|
|||
Yes.
Select the cell with the formula in it and pull_down: Format Cells... Number Custom the Type-in field will say General Your enter General" hello world" and you will see the result. If you do it this way you can still use the cell for math. -- Gary's Student "Brian" wrote: Just as the subject askes, I what to have a formula in a cell that the number that it puts out is then followed by whatever text i want. Is this possible? |
#5
|
|||
|
|||
Hi!
Try this: =your_formula_here&" your_text_here" Biff "Brian" wrote in message ... Just as the subject askes, I what to have a formula in a cell that the number that it puts out is then followed by whatever text i want. Is this possible? |
#6
|
|||
|
|||
you might need to explain a little more what you're trying to acheive. There are two ways, either: =[formula]&"text" or =[formula]&D4 (where cell D4 contains the text you want adding to the end) -- widemonk ------------------------------------------------------------------------ widemonk's Profile: http://www.excelforum.com/member.php...o&userid=20402 View this thread: http://www.excelforum.com/showthread...hreadid=475560 |
#7
|
|||
|
|||
... and brian is a guest so he wont see my reply -- widemonk ------------------------------------------------------------------------ widemonk's Profile: http://www.excelforum.com/member.php...o&userid=20402 View this thread: http://www.excelforum.com/showthread...hreadid=475560 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I create and save a formula for text fields? | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
Coverting Formula to Text | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |