Hello all,
I have an unsual question/task that I hope I may be able to get some help with. :wink:
I want to be able to take a collection of letters (a sentence or something like that) and be able to separate each individual character and place it in its own cell.
Probably will make more sense with an example:
I have two sheets. Sheet1 has the source data; Sheet2 is the sheet in which I’d like to place the result.
So, say in Sheet1 I have the following: (Please note that the ‘spaces’ are important)(I needed to put it in 'code' format so that the multiple 'spaces' were kept, and not removed by the forum)
Cell A1 contains the following:
Cell A2 contains:
Cell A3 contains:
Cell A4 contains:
Cell A5 contains:
Now, here is what I’d like to happen.
I would like a 'code' to go though each cell, take its contents, and separate each individual character and then place each of these individual characters into consecutive cells or the same row.
So, the formula would first take the contents of cell A1 on Sheet1 i.e. “ CCC A TTTTTTT”.
This would be taken apart, and on Sheet2 each character would be plotted into a separate cell on the same row.
So cell A1 on Sheet2 would contain a ‘space’ (appear to be blank),
cell B1 would contain a “C”,
cell C1 would contain a “C”,
cell D1 would contain a “C”,
cell E1 would contain a ‘space’,
cell F1 would contain a ‘space' ... and so on.
Once the first line has been separated and plotted, you’d move onto the next line.
And after each of the above cells is plotted, if you make the size (width, height) of your cells in Sheet2 square, the word/shape “CAT” should be formed.
Another example:
If I had in Sheet1:
Cell A1:
Cell A2:
Cell A3:
Cell A4:
Cell A5:
Cell A6:
Cell A7:
And then I did the same process of separating each character from each line (with spaces to be included as characters) and then plotted each of these character into its own separate cell on Sheet2, and if Sheet2 has ‘square-shaped’ cells, a big letter “X” would be formed.
Is there an easy way I could create ‘code’ that would enable me to do this?
I hope that the above made sense ...
Thank you all for any help you may be able to provide
Thanks for your time,
Cheers
KJ
I have an unsual question/task that I hope I may be able to get some help with. :wink:
I want to be able to take a collection of letters (a sentence or something like that) and be able to separate each individual character and place it in its own cell.
Probably will make more sense with an example:
I have two sheets. Sheet1 has the source data; Sheet2 is the sheet in which I’d like to place the result.
So, say in Sheet1 I have the following: (Please note that the ‘spaces’ are important)(I needed to put it in 'code' format so that the multiple 'spaces' were kept, and not removed by the forum)
Cell A1 contains the following:
Code:
CCC A TTTTTTT
Cell A2 contains:
Code:
C A A T
Cell A3 contains:
Code:
C A A T
Cell A4 contains:
Code:
C AAAAAAA T
Cell A5 contains:
Code:
CCC A A T
Now, here is what I’d like to happen.
I would like a 'code' to go though each cell, take its contents, and separate each individual character and then place each of these individual characters into consecutive cells or the same row.
So, the formula would first take the contents of cell A1 on Sheet1 i.e. “ CCC A TTTTTTT”.
This would be taken apart, and on Sheet2 each character would be plotted into a separate cell on the same row.
So cell A1 on Sheet2 would contain a ‘space’ (appear to be blank),
cell B1 would contain a “C”,
cell C1 would contain a “C”,
cell D1 would contain a “C”,
cell E1 would contain a ‘space’,
cell F1 would contain a ‘space' ... and so on.
Once the first line has been separated and plotted, you’d move onto the next line.
And after each of the above cells is plotted, if you make the size (width, height) of your cells in Sheet2 square, the word/shape “CAT” should be formed.
Another example:
If I had in Sheet1:
Cell A1:
Code:
X X
Code:
X X
Code:
X X
Code:
X
Code:
X X
Code:
X X
Code:
X X
And then I did the same process of separating each character from each line (with spaces to be included as characters) and then plotted each of these character into its own separate cell on Sheet2, and if Sheet2 has ‘square-shaped’ cells, a big letter “X” would be formed.
Is there an easy way I could create ‘code’ that would enable me to do this?
I hope that the above made sense ...
Thank you all for any help you may be able to provide
Thanks for your time,
Cheers
KJ