Re: Pulling text from a cell
- From: Domenic <domenic22@xxxxxxxxxxxx>
- Date: Thu, 09 Nov 2006 11:27:18 -0500
Try...
=LEFT(A1,FIND(" ",A1)-1)
and
=MID(A1,FIND(" ",A1)+1,1024)
To return numerical values, try the following instead...
=LEFT(A1,FIND(" ",A1))+0
and
=MID(A1,FIND(" ",A1),1024)+0
Hope this helps!
In article <1163086558.418792.260580@xxxxxxxxxxxxxxxxxxxxxxxxxxx>,
"jnasr" <nasr.joseph@xxxxxxxxx> wrote:
I copied some data down to excel from the internet (no .xls or .csv.
download available, just a straight copy and paste, unfortunately).
The data is in the format below:
5,503,522 7,268,551
There is a space between the numbers. I have used right, left, find
and len formulas in the past to separate text like this, but I'm having
trouble with this one.
Assuming the above data was in cell A1, I initially tried using the
formula
=RIGHT(A1,FIND(" ",A1))
However, this returns 551. I checked this and running FIND(" ",A1)
returns a value of 3. This doesn't make sense to me either, but if
anyone could explain a solution or why the FIND formula I was using was
returning that particular value, I would appreciate it.
Thanks.
- References:
- Pulling text from a cell
- From: jnasr
- Pulling text from a cell
- Prev by Date: Re: Pulling text from a cell
- Next by Date: RE: Dynamic name
- Previous by thread: Re: Pulling text from a cell
- Next by thread: Re: Pulling text from a cell
- Index(es):
Relevant Pages
|
