hi all
i have copied a column of data from web page and
pasted it into COL-A, all cells containing numbers..!
but i could not use the cell values
for arithmatical operations..!
i used the TTC function &
when i checked with "A1+0" i am getting #value error..!
the *trim* & *clean* functions also not yielding
any results..!
what could be the problem and how i can i
use the data for arithmatical operations..?
any help please..!
-via135
Last edited by via135; 03-15-2010 at 12:58 PM.
Select the data, Find & Replace, in the Find box press and hold the Alt key, and on the NUMERIC keypad, type 0160.
Leave the Replace box blank, Replace All.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
What do the formulas yield?
=Left(A1) and =Right(A1) yield (where A1 is a cell containing one of those numbers)
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
yes..alt+0160 worked well..!
till datei was of the opinion that
it (alt+0160) is meant for msword only..!
i learned a new thing..!
thanks shg..!
-via135
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks