| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
using text with a function
How do you use text with a simple function in the same cell.
Example: =B54/4.5 this would show up as 5 I would like it to read: Total 5, or 5 Total ?? =B54/4.5,"Total" ?? This of course does not work. Any help with this would be greatly appreciated! Thanks |
|
#2
|
|||
|
|||
|
type
="total" & " " & B54/4.5 J.W. wrote in message ... How do you use text with a simple function in the same cell. Example: =B54/4.5 this would show up as 5 I would like it to read: Total 5, or 5 Total ?? =B54/4.5,"Total" ?? This of course does not work. Any help with this would be greatly appreciated! Thanks |
|
#3
|
|||
|
|||
|
J.W
A formula like this will work ="Total "&B54/4.5 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "J.W." wrote in message ... How do you use text with a simple function in the same cell. Example: =B54/4.5 this would show up as 5 I would like it to read: Total 5, or 5 Total ?? =B54/4.5,"Total" ?? This of course does not work. Any help with this would be greatly appreciated! Thanks |
|
#4
|
|||
|
|||
|
In addition to previous replies, if you want to preserve the format of the
numbers you get you can use the TEXT() function: ="Total " & TEXT(B54/4.5,"0.00") or ="Total " & TEXT(B54/4.5,"0.0%") or ="Total " & TEXT(B54/4.5,"#,##0") etc. etc. Regards, KL "J.W." wrote in message ... How do you use text with a simple function in the same cell. Example: =B54/4.5 this would show up as 5 I would like it to read: Total 5, or 5 Total ?? =B54/4.5,"Total" ?? This of course does not work. Any help with this would be greatly appreciated! Thanks |
|
#5
|
|||
|
|||
|
You can also custom format the formula cell as:
"Total "0.00 J.W. wrote: How do you use text with a simple function in the same cell. Example: =B54/4.5 this would show up as 5 I would like it to read: Total 5, or 5 Total ?? =B54/4.5,"Total" ?? This of course does not work. Any help with this would be greatly appreciated! Thanks |
|
#6
|
|||
|
|||
|
Thank you all, very helpfull and they worked the way I wanted.
Thanks! "J.W." wrote: How do you use text with a simple function in the same cell. Example: =B54/4.5 this would show up as 5 I would like it to read: Total 5, or 5 Total ?? =B54/4.5,"Total" ?? This of course does not work. Any help with this would be greatly appreciated! Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| TEXT function to format a date in English & French | Excel Worksheet Functions | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
| Excel IF function for text | Excel Worksheet Functions | |||
| Adding text before a function | Excel Worksheet Functions | |||
Linear Mode
