A
adeel via OfficeKB.com
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.
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.