Reverse Concantenate?

  • Thread starter Thread starter Dawn
  • Start date Start date
D

Dawn

Is this possible? I have a single cel that contains a list like this.

filename.jpg
filename2.jpg
filename3.jpg
filename4.jpg

Is there a way to move this to separate cels? I would prefer the information
in stacked rows?

Thanks from a newbie!
 
Dawn,

presumable the filenames are separated by the newline character
(CHAR(10)). If you want to avoid VBA you can first replace this
character with a dash. In another cell:

=SUBSTITUTE(A2,CHAR(10),"-")

Then you can apply Data>Text to columns... To break it in columns.

Next thing is you can copy and Paste Special... check the Transpose
button.

HTH
Kostis Vezerides
 
Back
Top