Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |