Brand new user, appreciate the help!

I have a contact data in a specific vertical index in a single column.

I wanted to set up an array forumla to automatically transpose the data
horizontally. Couldn't do it because obviously the array function can
not use text.

I then tried to set up a simple replacement fuction (=AXX) into each
cell. But that wouldn't work, because as I moved horizontally the
Column would change.

I quit, and then simply did the manual transpose.

Is there an alternative?


--
EMCUE
------------------------------------------------------------------------
EMCUE's Profile: http://www.excelforum.com/member.php...o&userid=32945
View this thread: http://www.excelforum.com/showthread...hreadid=527719