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"
wrote in message
...
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.....