Thread: Can unmerged cell contents be split to another cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default Can unmerged cell contents be split to another cell
=right(vin #,7) will get the last 7 characters
=left(vin#,10) will get the first 10 characters

"Karyn" wrote:

I have 17 digit/letter combination (vehicle VIN) that was imported in to
excel. The VIN number was not merged, it came over in one cell. I would
like to separate the last seven characters (our stock #) into a different
cell. Is this possible?
Reply With QuoteReply With Quote