Pulling text from a cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "jnasr" <nasr.joseph@xxxxxxxxx>
Date: 9 Nov 2006 07:35:58 -0800

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.

.

Follow-Ups:
- Re: Pulling text from a cell
  - From: David Biddulph
- Re: Pulling text from a cell
  - From: Domenic
- Re: Pulling text from a cell
  - From: Saruman

Prev by Date: Re: Need help implementing EPA rounding method
Next by Date: Re: Interaction of form controls and pictures in Excel 2007
Previous by thread: Re: Using =TRIM()
Next by thread: Re: Pulling text from a cell
Index(es):
- Date
- Thread

Relevant Pages

RE: Comma delimiter for csv downloads?
... If the file does not have an extension, ... > The files have commas, and when Excel is using comma as delimiter all is ... if I download and try to ... > force them to save as .csv, then they will open correctly in future. ...
(microsoft.public.excel.misc)
Re: Weekly Transaction Processing
... switch the file reference to that of the new source CSV. ... I also found that the XLS will not read a closed CSV automatically like how ... > Then open your XLS file in which you would have changed all file references ...
(microsoft.public.excel.worksheet.functions)
Re: Ftp from within excel
... ie when the sql server generated a csv file, this process is completed, the ... > connection when that file is done and then to start download. ... > Dim strDirectoryList As String ...
(microsoft.public.excel.programming)
Re: Ftp from within excel
... ie when the sql server generated a csv file, this process is completed, the ... > connection when that file is done and then to start download. ... > Dim strDirectoryList As String ...
(microsoft.public.excel.charting)
Re: Ftp from within excel
... ie when the sql server generated a csv file, this process is completed, the ... > connection when that file is done and then to start download. ... > Dim strDirectoryList As String ...
(microsoft.public.excel.misc)