Excel formula

[Threnody]

Hi

Is there a formula that is kind of the opposite to concatenating a row? Ie. That you can run that will make each character within a cell appear in it's own single cell.

For example,

One of my fields might be

|Tuesday|

I need this to be broken into

|T|u|e|s|d|a|y|

Any ideas?

Thanks for all your help.
Threnody

 

[Zathras]

One way would be to use Data/Text to Columns... Fixed width, and click a column break on each position.

Another way would be to use the MID function:
=MID($A$1,1,1)
=MID($A$1,2,1)
=MID($A$1,3,1)
etc.

A third way would be to use a VBA macro.

 

[Threnody]

Thank you so much! You're a legend.

T.