Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract characters from a cell
I am trying to extra to extract certain characters from a cell. I know this should be easy, but I am having a lot of trouble figuring out how. Each cell has a different amount of characters, and I want the 1st character and the 5th character from the end. Here are a couple examples: dinosaur -- do minneapolis -- mp Please help, Thanks -- JBasch ------------------------------------------------------------------------ JBasch's Profile: http://www.excelforum.com/member.php...o&userid=32329 View this thread: http://www.excelforum.com/showthread...hreadid=520874 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How to extract just the Column Name of the active cell | Excel Discussion (Misc queries) | |||
Display text 1024 characters in a cell | Excel Worksheet Functions | |||
how to extract data from a cell in a formula in another cell | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel |