Putting text at the end of formula results

**stephens** · 01-08-2010, 02:19 PM

I'm trying to enter relatively simple drug calculation formulas in Excel where the result is appended with the proper units to administer. For example, if I'm calculating for units of regular insulin with a formula such as:

=0.75*f2

I'd like the cell to make the above calculation, and append it with "Units Reg Insulin" or something similar. Thus far, I've just been putting the units as text in adjacent cells but the result looks a bit messy.

Is this possible? I'm using Excel 2007 and the Help index does not seem to offer much guidance about this.

Thank you for any help!

**khamilton** · 01-08-2010, 02:26 PM

to join text at the end of your formula put this
&"Units Reg Insulin"

**darkyam** · 01-08-2010, 02:40 PM

Alternately, custom format as General" Units Reg Insulin" and then use the formula you already have.

**stephens** · 01-08-2010, 02:42 PM

khamilton wrote: "to join text at the end of your formula put this
&"Units Reg Insulin""

Thanks. I tried that, but what happens is the formula, which I specify to calculate to 0 decimal points, calculates to 16 decimal points instead, sweeping the text out of the cell. Is this some sort of glitch? When attempting to reformat the decimal places, 0 still appears in the formatting despite the spreadsheet calculating to 16 decimal places. Hmmm.

**darkyam** · 01-08-2010, 02:45 PM

Are you using a Round function in your formula? If you want 0 decimal places, you can change my suggestion to 0" Units Reg Insulin", and that will also round automatically.

**stephens** · 01-08-2010, 02:57 PM

darkyam, that DOES work. In case anybody else comes to this thread and is interested in the function darkyam suggests, go to Format Cells, Custom, Type:, and type

0 "Whatever Text You Want to Appear"

It would be nice to be able to apply the text the way khamilton suggests, though. Any thoughts as to why I experience the apparent glitch?

**darkyam** · 01-08-2010, 03:00 PM

I don't see any rounding function in your original formula. If you changed it to =Round(.75*F2,0)&" Units Reg Insulin", it should come out with the same result.

**shg** · 01-08-2010, 03:47 PM

What darkyam suggests is preferable, IMO; the result is a number and can be used in further calculations. The units are just formatting.

With khamilton's suggestion (which is appropriate for some circumstances), the result is text. The number will appear in full precision unless you format (or round) it:

=text(A1, "0") & " your text"

**stephens** · 01-08-2010, 04:07 PM

OK. Thank you all for helping me understand this!

Putting text at the end of formula results

LinkBack

Thread Tools

Rate This Thread

Display

Putting text at the end of formula results

Re: Putting text at the end of formula results

Re: Putting text at the end of formula results

Re: Putting text at the end of formula results

Re: Putting text at the end of formula results

Re: Putting text at the end of formula results

Re: Putting text at the end of formula results

Re: Putting text at the end of formula results

Re: Putting text at the end of formula results

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions