Assuming texting is in A1
For AA: =LEFT(A1,FIND("/",A1)-1)
For DZ: =MID(A1,FIND("/",A1)+1,FIND("/",A1,FIND("/",A1)+1)-FIND("/",A1)-1)
For EA:
=MID(A1,FIND("/",A1,FIND("/",A1)+1)+1,LEN(A1)-FIND("/",A1,FIND("/",A1)+1))

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