In A3: =MID($A$1,ROW(A1)*3-2,2)
copy down

"lindsayhyle" wrote:

I have a list of text like in a cell like this:
AA/DZ/EA
and I want to pull it out of one cell and put in into different cells like
this:
AA
DZ
EA
Is there a way to do that other than typing it individually (for longer
lines of text)? Thanks.