Posted to microsoft.public.excel.worksheet.functions
|
|
Return the 6th thru the nth character?
=MID(A1,6,999)
"Beege" wrote in message
...
HBF
=RIGHT(cell,5)
Beege
"HBF" wrote in message
...
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
|