Formula Question

J

Joe

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?
 
P

protonLeah

Yes:
"=MID(source,start,length)"

For the example given:
Source = D1,
start = 1, i.e., the first character in the string,
length =1, i.e., the number of characters to copy

Of course, if number of characters to be copied varies, as I suspect,
it gets more complicated, nor did you explain the significance of the
caret after the '5' character.
 
T

tim m

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.
 
J

JE McGimpsey

If the number is always left paren followed by one digit:

D1: =--MID(A1,2,1)

if there may be more digits, but they're always followed by a caret (^):

D1: =--MID(A1,2,FIND("^",A1)-2)
 
J

Joe

Thanks for the help.

JE McGimpsey said:
If the number is always left paren followed by one digit:

D1: =--MID(A1,2,1)

if there may be more digits, but they're always followed by a caret (^):

D1: =--MID(A1,2,FIND("^",A1)-2)
Click to expand...
 
J

Joe

yes there may be more than one digit before the ^. 2 digits maximum ex.
10^Inlet
the ^ stands for offset. A symbol we use. All I want to do is return the
number before the ^ to another cell as I explained before.
 
J

JE McGimpsey

The OP's example has a left paren before the 5, so you'd use
MID(A1,2,...) rather than LEFT(A1,...)
 
Top