Export text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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))
 
Depending whether your source cells pattern is consistant. If it holds as
AA/DZ/EA XX/XX/XX then

If above cell is in A1;
In B1 enter: =Left(A1,2)
In C1 enter: =Mid(A1,4,2)
In D1 enter: = Right(A1,2)

Should work for you,,,
Jim May
 
Thank you all

Jim May said:
Depending whether your source cells pattern is consistant. If it holds as
AA/DZ/EA XX/XX/XX then

If above cell is in A1;
In B1 enter: =Left(A1,2)
In C1 enter: =Mid(A1,4,2)
In D1 enter: = Right(A1,2)

Should work for you,,,
Jim May
Click to expand...
 
Theethless,
Next to your name I see a bronze stat, but on another post from today I see
a silver star. ?
 
Thank you all

Tevuna said:
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))
Click to expand...
 
Back
Top