For your specific example you could use the function 'LEFT'

=LEFT(D1,1) This will look at cell D1 and return the left most character.

"Joe" wrote:

Is there a formula that will return only partial data from one cell to another?
Ex. Cell D1 contains (5^Inlet) And I want to write a formula that will only
return the number 5 of cell D1 to Cell A1. Is this possible?