Removing 3-4 decimals

[Ty]

I need to remove 3 to 4 decimals in a cells in one column. I know it
has something to do with LEFT and something else. Here is the
example:

7.1.2.5 need to convert it to 7125

Thanks.....

 

[Jim Cone]

Use the Substitute function.
--
Jim Cone
Portland, Oregon USA .
http://www.contextures.com/excel-sort-addin.html .
editorial review of excel sorting add-in (30 ways to sort)



"Ty" <[email protected]>
wrote in message
news:bc197710-7c72-4bb3-8752-b7a7d0a5735e@r20g2000yqd.googlegroups.com...

 

[Gord Dibben]

Can you cut that column and paste to a new worksheet then run Edit>Replace on
it?

Then paste back into original spot.


Gord Dibben MS Excel MVP

 

[Rick Rothstein]

Can you cut that column and paste to a new

worksheet then run Edit>Replace on it?

Then paste back into original spot.

I'm curious... why copy it to another sheet, do the replace and then copy it
back instead of just doing the replace at the original location?

Rick Rothstein (MVP - Excel)

 

[Gord Dibben]

Just to make sure you do not inadvertantly replace any other decimal points in
other columns.

I do not trust Excel to operate on just the range I have selected when doing an
edit>replace.

If that is the only column with DP then no problem with your suggestion.


Gord

 

[Ty]

Just to make sure you do not inadvertantly replace any other decimal points in
other columns.

I do not trust Excel to operate on just the range I have selected when doing an
edit>replace.

If that is the only column with DP then no problem with your suggestion.

Gord





- Show quoted text -

The SUBSTITUTE vs REPLACE? I used the SUBSTITUE in an additional
column on same sheet because I still need to see the other column.
Works great!

SUBSTITUTE(G265,".","")

 

[Rick Rothstein]

....because I still need to see the other column

You might have considered mentioning that in your original posting.

Rick