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?
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?
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.
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?
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 <7F5E5A74-A9C8-4EE5-B0C8-9E1F312A0E41@microsoft.com>,
Joe <Joe@discussions.microsoft.com> 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?
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 <7F5E5A74-A9C8-4EE5-B0C8-9E1F312A0E41@microsoft.com>,
> Joe <Joe@discussions.microsoft.com> 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?
>
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?
Wouldn't the formula be:
=left(A1,find("^",A1,1)-1)
Wouldn't the formula be:
=left(A1,find("^",A1,1)-1)
The OP's example has a left paren before the 5, so you'd use
MID(A1,2,...) rather than LEFT(A1,...)
In article <1147580293.868472.78770@v46g2000cwv.googlegroups.com>,
"TKnTexas" <tkntexas55@aol.com> wrote:
> Wouldn't the formula be:
>
> =left(A1,find("^",A1,1)-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks