G
Guest
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.
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.