| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I pick up characters after the first 4 in Excel cell
I have a cell containing digits and alpha numeric characters. I want to pick
up just the alpha numeric characters which are all after the first four characters in the cell. Is there formula I can use without having to split out the first 4 characters with the formula LEFT... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I pick up characters after the first 4 in Excel cell
=RIGHT(A1,LEN(A1)-4)
"KKay" wrote: I have a cell containing digits and alpha numeric characters. I want to pick up just the alpha numeric characters which are all after the first four characters in the cell. Is there formula I can use without having to split out the first 4 characters with the formula LEFT... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I pick up characters after the first 4 in Excel cell
Many Thanks that was very helpful exactly what i needed.
"Toppers" wrote: =RIGHT(A1,LEN(A1)-4) "KKay" wrote: I have a cell containing digits and alpha numeric characters. I want to pick up just the alpha numeric characters which are all after the first four characters in the cell. Is there formula I can use without having to split out the first 4 characters with the formula LEFT... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I pick up characters after the first 4 in Excel cell
depending exactly how many characters you have and want you should be using
MID or even Right -- paul remove nospam for email addy! "KKay" wrote: I have a cell containing digits and alpha numeric characters. I want to pick up just the alpha numeric characters which are all after the first four characters in the cell. Is there formula I can use without having to split out the first 4 characters with the formula LEFT... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I pick up characters after the first 4 in Excel cell
Thanks PAul used the RIGHT formula and worked out.
"paul" wrote: depending exactly how many characters you have and want you should be using MID or even Right -- paul remove nospam for email addy! "KKay" wrote: I have a cell containing digits and alpha numeric characters. I want to pick up just the alpha numeric characters which are all after the first four characters in the cell. Is there formula I can use without having to split out the first 4 characters with the formula LEFT... |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I pick up characters after the first 4 in Excel cell
Nel post
*KKay* ha scritto: I have a cell containing digits and alpha numeric characters. I want to pick up just the alpha numeric characters which are all after the first four characters in the cell. Is there formula I can use without having to split out the first 4 characters with the formula LEFT... I think you can use RIGHT function: =RIGHT(B6,LEN(B6)-4) where B6 is the cell with your alphanumeric characters. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I pick up characters after the first 4 in Excel cell
Thanks Franz, that was very helpful, exactly what I needed.
"Franz Verga" wrote: Nel post *KKay* ha scritto: I have a cell containing digits and alpha numeric characters. I want to pick up just the alpha numeric characters which are all after the first four characters in the cell. Is there formula I can use without having to split out the first 4 characters with the formula LEFT... I think you can use RIGHT function: =RIGHT(B6,LEN(B6)-4) where B6 is the cell with your alphanumeric characters. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
| How do I make a drop down list to pick from for a cell in Excel | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
