| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to extract characters ?
Dear Sir,
I wish to extract the last 6 characters if a cell in column A has 13 characters, otherwise only extract the last 3 characters. Illustration: A B 1 510104BGH9006 BGH9006 2 510104TRL TRL 3 510104OTH9016 OTH9016 4 510202HLG HLG 5 510104KJY9018 KJY9018 6 510203FTP FTP 7 510104IPL9023 IPL9023 8 510209SGS SGS May I know what formula must input at cell B1 and copy downwards to get the answer ? Thanks Low -- A36B58K641 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : How to extract data from columns ? | Excel Discussion (Misc queries) | |||
| How can I enter spanish accented characters into excel 2002? | Excel Discussion (Misc queries) | |||
| Excel 2002: Single step of selecting characters | Excel Discussion (Misc queries) | |||
| Excel 2002 : How to extract references from a list ? | Excel Discussion (Misc queries) | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
Threaded Mode
