Forum Discussion
Solved
Harvesting letters
Hi everyone. Can you be so kind and generous to help me solving this issue: 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...
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:
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:
Thank you bro ... Mission Accomplished, thanks to you.