| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep last 4 characters of value
Hi,
I need to remove the last 4 characters of value (b1). I also need to remove all preceeding characters except the last 4 characters of a value (c1) Each value is of a different lenght. IE a1= 1234567890 (original value) b1=123456 c1=7890 Thanks in advance, AW |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How many characters in a box..? | Excel Worksheet Functions | |||
| In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
| sum of characters | Excel Discussion (Misc queries) | |||
| Hex Characters | Excel Worksheet Functions | |||
Threaded Mode
