Amy,

If it's not too late, put the two measurements in separate cells. Having to
separate them in your formulas is doable, but a bit messy. You might rather
just hit yourself on the head with a bat, which you might feel like doing if
you've already entered a lot of these combined into one cell. If you have,
post back, and we'll talk about using Data - Text to Columns to split them.
Life will be much nicer.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Amy Lyn" <Amy wrote in message
...
Is there a formula to display text in cell as abbreviated measurements?

Ex.
I type - 18 18
Cell is displayed as - 18" x 18"

I type 12 6.5
Cell is displayed as - 12" x 6 1/2"