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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to extract characters ?
B1 contents is
=IF(LEN(A1)=13,RIGHT(A1,6),RIGHT(A1,3)) Mr. Low wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to extract characters ?
Hi,
I've assumed you mean = 13 but if I'm incorrect in that assumption use the second version. the formula can be dragged =IF(LEN(A1)=13,RIGHT(A1,6),RIGHT(A1,3)) =IF(LEN(A1)=13,RIGHT(A1,6),RIGHT(A1,3)) Mike "Mr. Low" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to extract characters ?
Hello Bob,
Thanks for the formula. Low -- A36B58K641 "Bob I" wrote: B1 contents is =IF(LEN(A1)=13,RIGHT(A1,6),RIGHT(A1,3)) Mr. Low wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to extract characters ?
Hello Mike,
Thanks for the formula. I need the second one. Kind Regards Low -- A36B58K641 "Mike H" wrote: Hi, I've assumed you mean = 13 but if I'm incorrect in that assumption use the second version. the formula can be dragged =IF(LEN(A1)=13,RIGHT(A1,6),RIGHT(A1,3)) =IF(LEN(A1)=13,RIGHT(A1,6),RIGHT(A1,3)) Mike "Mr. Low" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to extract characters ?
You're welcome, have a great day.
Mr. Low wrote: Hello Bob, Thanks for the formula. Low |
Reply |
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 |