View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David P. David P. is offline
external usenet poster
 
Posts: 67
Default Splitting a cell by number of characters from the end

Is there a way to split a cell by specifiying how many characters from the
end? This sounds crazy but here is what I mean, the cell might contain in A1
for example:

"Here is the product code: 1296.2496.80."

Can I split A1 into 5 different cells like this:

B1 = characters 1,2, & 3 from the end which would yield "80."
C1 = characters 4, 5, & 6 from the end which would yield "96."
D1 = characters 7 & 8 from the end which would yield "24"
E1 = characters 9, 10, & 11 from the end which would yield "96."
F1 = characters 9, 10, & 11 from the end which would yield "12"

I would prefer to split it this way since I am having to retrofit something
into a huge project but if that isn't possible your suggestion on a website
that explains the various ways you can split a cell it would be greatly
appreciated. Thank you.

--
David P.