Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return the 6th thru the nth character?
I have data in cells that are formatted in a code.name format I need the name, but not the code - the code is always 5 characters. The name lenght is random. How do I get rid of the code and keep the name? -- HBF ------------------------------------------------------------------------ HBF's Profile: http://www.excelforum.com/member.php...o&userid=34019 View this thread: http://www.excelforum.com/showthread...hreadid=554277 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
want to return "n/a" or "0" | New Users to Excel | |||
If it's not a space, return the cell contents. | Excel Worksheet Functions | |||
Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions |