Thread: Return the 6th thru the nth character?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HBF
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote