Extract Some Correctors from a cell
 

I have large amount of cells with text & numeric values, shown some thing
like that;

XX-06-AAA-01 AAAA BBB XX DD EE FJDD SS (this value is in one
cell)

Now, I want to extract values from that cell leaving the first 12 correctors
for example I only want "AAAA BBB XX DD EE FJDD SS" the first 12 correctos
for example "XX-06-AAA-01" would be errased. Is there any function/formula.
please help me.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

Extract Some Correctors from a cell
 

Try this

=MID(A1,13,255)



On Sep 14, 10:46*am, "adeel via OfficeKB.com" <u32736@uwe wrote:
I have large amount of cells with text & numeric values, shown some thing
like that;

XX-06-AAA-01 AAAA BBB XX DD EE FJDD SS * * * * * * *(this value is in one
cell)

Now, I want to extract values from that cell leaving the first 12 correctors
for example I only want "AAAA BBB XX DD EE FJDD SS" the first 12 correctos
for example "XX-06-AAA-01" would be errased. Is there any function/formula.
please help me.

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200809/1