Hello,

I need to tranpose a long list of text values that I have running from
A1:A400 into A1 - XX#

When I try to paste special it tells me that the cells are not the same
width.

Is there any way around this?