Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell extract | Excel Worksheet Functions | |||
Extract Column Letter from Cell Reference in another Cell | Excel Discussion (Misc queries) | |||
Extract From Cell | Excel Worksheet Functions | |||
how to extract data from a cell in a formula in another cell | Excel Worksheet Functions | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) |