Thread: Extract Some Correctors from a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
adeel via OfficeKB.com adeel via OfficeKB.com is offline
external usenet poster
  
Posts: 37
Default 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

Reply With QuoteReply With Quote