Hey ya'll. I've tried about a million different combinations of formulas to do what I'm needing here and I know it is way simpler than I'm making it.
I know how to split a cell that has a double digit number into two separate cells. I have one cell that will take the left digit and another that will take the right digit. My problem is, if the data cell has only one digit, I need the right to take it, but the left to be 0.
Say C2 is the number 23. I need C3 to take the left 2 and D3 to take the right 3. That part I got.
But say C2 is 7. I need C3 to be 0 and D4 to be the 7.
I'm really only needing a formula for C3 that takes the left number. D3 will always take the right, so it's good to go.
Here is the formula I'm using for C3, and I think there's a way to add to it if there is no left, to just place a 0 there. I'm not sure.
=LEFT(C3)+0
I know it's something simple, it's just eluding me like crazy. Any ideas???? Much great thanks in advance!!!!
Bookmarks