Export text
 

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.

Export text
 

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.

Export text
 

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.

Export text
 

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

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

Export text
 

Thank you all

"Jim May" wrote:

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

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

Export text
 

Thank you all

"Teethless mama" wrote:

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.

Export text
 

Theethless,
Next to your name I see a bronze stat, but on another post from today I see
a silver star. ?

"Teethless mama" wrote:

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.

Export text
 

Thank you all

"Tevuna" wrote:

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.