excel formula's

M

morkz

Hi

Just wondering how abouts do you write a forumula in excel.

I have some problems with some data where it needs to be reformated and
there is over 10,000 records.

my problem is i have some currecy i.e. 0,000 or 45 000,00 and what i
need to do is first remove the comma (,) with a decimal and then move
along and remove any spaces.

anyone got some ideas or point me in the write direction in.
 
O

Otto Moehrbach

For the commas, select your entire range and then click on Edit - Replace.
In the Replace What space type a comma. In the Replace With space type a
period. Click Replace All.
Removing the spaces is a little longer and will involve doing it on one
column at a time, assuming you want to do this to more than one column.
Assuming you want to
remove the spaces in Column A starting in A2, in row 2 of any free column
enter "=Trim(A1)" without the quotes. Drag this down as far as Column A
goes. Now copy all of this new column. Then select A2 and do Edit -
PasteSpecial - Values. This will complete Column A. You can now delete the
new column you added and move on to doing the same thing with another
column. Post back if you need more. HTH Otto
 
D

David McRitchie

Unless the data is numeric =ISNUMBER(A1)
if they are numbers, one would simply format the cell as wanted
and numbers would instantly format, unlike conversions from
text to numbers or numbers to text. Of course the poster should
have included whether data was text or numbers to begin with.
 
Top