Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number of characters in a cell | Excel Discussion (Misc queries) | |||
Is there maximum number of characters per cell? | Excel Discussion (Misc queries) | |||
set the number of characters in a cell | Excel Discussion (Misc queries) | |||
How can i specify a cell to have a fixed number of characters | Excel Discussion (Misc queries) | |||
Max number of characters in a cell | Excel Discussion (Misc queries) |