Forum Discussion

Brass Contributor

Jul 08, 2018

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...

Formulas & Functions

Requests

Haytham Amairah
Jul 09, 2018
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:

Haytham Amairah

Silver Contributor

Jul 08, 2018

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

Mahmoud AlJammal

Brass Contributor

Jul 09, 2018

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 ...

Haytham Amairah
Silver Contributor
Jul 09, 2018
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:
- Mahmoud AlJammal
  Brass Contributor
  Aug 04, 2018
  Thank you bro ... Mission Accomplished, thanks to you.