Forum Discussion
Harvesting letters
I need excel to extract letters from a certain cell containing text, and give it to me in a certain column.
Let say I copy/paste (I love you) in a certain cell, I need excel to put (I) then (empty cell), then (l) then (o) then (v) then (e) ... Consecutively in a column.
Thank you so much for your kindness.
Hi Mahmoud,
If so, please use this little formula instead:
=MID($A$1,ROW(A1),1)
Put it somewhere in the worksheet, and then drag it down across the rows to get a result like this:
4 Replies
Hi Mahmoud,
There is a powerful tool in Excel called (Text to Columns), and it can perfectly do what you asking for.
However, I found this https://www.youtube.com/watch?v=misq9_2sJ4o talking about what you are asking for, and how to solve it using that tool and using a formula as well.
Regards
Thank you very much bro ... this is exactly what I wanted, but I need the extracted characters to be in a column, not a row.
I know it shouldn't be a problem, but this is something that I need to add to an existing sheet ...
Thanks again ...
Hi Mahmoud,
If so, please use this little formula instead:
=MID($A$1,ROW(A1),1)
Put it somewhere in the worksheet, and then drag it down across the rows to get a result like this:
