from my archives
sometime back i used this formula
=OFFSET($B$1,MATCH($B$16,B1:B16,0)-1,0)


my original data is in B1 to B16
I copied this to any cell and copy down

try this.
may be easier solutions available




tryer wrote in message
...

Hi,

Is it possible to invert text by 180 deg. Under Format - cells you only
have the option of 90 deg.


--
tryer
------------------------------------------------------------------------
tryer's Profile:
http://www.excelforum.com/member.php...o&userid=16546
View this thread: http://www.excelforum.com/showthread...hreadid=399793