Is it possible to disassemble text? (i.e. if Cell A1="AR-01", can I separate the AR?

S

shadestreet

I have several cells of text in the form:

"AA-##-AA-##-A" where the "A" represents a letter and the "#
represents a number. Is it possible to seperate the components betwee
the dashes into separate cells
 
A

Andrew

If the text and hyphens are always in the same position, how abou
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,MID(A1,6,4),""),LEFT(A1,3),""),RIGHT(A1,2),"")
 
D

Dave Peterson

You could:

Select your range (single column at a time)
Data|Text to columns
delimited (by hyphen)
and finish up.

(make sure you don't overwrite anything you don't want to.)
 
G

Greg

shadestreet said:
I have several cells of text in the form:

"AA-##-AA-##-A" where the "A" represents a letter and the "#"
represents a number. Is it possible to seperate the components between
the dashes into separate cells?
Click to expand...

Use Data>Text-to-Columns, and use a dash as your delimiter.
 
H

Harlan Grove

Andrew > said:
If you just want the numbers, try
=SUBSTITUTE(SUBSTITUTE(A1,"-",""),"A","")
Click to expand...

Is it really sooooo difficult to *read* the OP's message *carefully*?

"Is it possible to seperate the components between
the dashes into separate cells?"

How could you believe your formula above comes remotely close to doing what
the OP requested?
 
Top