Formula Question
 

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?

Formula Question
 

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.


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=541882

Formula Question
 

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?

Formula Question
 

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)


In article ,
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?

Formula Question
 

Thanks for the help.

"JE McGimpsey" wrote:

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)


In article ,
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?

Formula Question
 

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.

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

Formula Question
 

Wouldn't the formula be:

=left(A1,find("^",A1,1)-1)

Formula Question
 

Wouldn't the formula be:

=left(A1,find("^",A1,1)-1)

Formula Question
 

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

In article . com,
"TKnTexas" wrote:

Wouldn't the formula be:

=left(A1,find("^",A1,1)-1)