G
Guest
This is probably really simple but for some reason I can't figure it out.
Here is the problem I have one cell that contains a long ID#
And one Call that has a quantity and I-d like to show a range of values
based on that quantity but only display the last few characters
For Example
A1: 3ex21h200 - ID#
B1: 45 - Quantiny
Using the =RIGHT(A1,4), I can show just the h200
What I'd like to show is a range that will automatically populate based on
the quantity. And not have to manually imput anything!
For Example
C1: h200 - h245
So far all I can do is get the cell to show the 200 anything I type onto the
end of that formula gives me a formula error, I'm sure there is some way to
close to formula and add tex or other characters, like the hyphen, but I
don't know haw any help would be greatly appreciated. Thanks!
Here is the problem I have one cell that contains a long ID#
And one Call that has a quantity and I-d like to show a range of values
based on that quantity but only display the last few characters
For Example
A1: 3ex21h200 - ID#
B1: 45 - Quantiny
Using the =RIGHT(A1,4), I can show just the h200
What I'd like to show is a range that will automatically populate based on
the quantity. And not have to manually imput anything!
For Example
C1: h200 - h245
So far all I can do is get the cell to show the 200 anything I type onto the
end of that formula gives me a formula error, I'm sure there is some way to
close to formula and add tex or other characters, like the hyphen, but I
don't know haw any help would be greatly appreciated. Thanks!