excel formula's

[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.

[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
"morkz" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> morkz
> ------------------------------------------------------------------------
> morkz's Profile:
> http://www.excelforum.com/member.php...o&userid=32059
> View this thread: http://www.excelforum.com/showthread...hreadid=519200
>

[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.

"Otto Moehrbach" <[email protected]> wrote...
> 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

[Otto Moehrbach]

Thanks David. That is a good point to keep in mind. Otto
"David McRitchie" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
> "Otto Moehrbach" <[email protected]> wrote...
>> 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
>
>