Excel deleting some numbers from an excel document
I have a spread sheet that has (example) numbers in a cell 45% (5/11) in a
cell or 60% (60/100) in a cell. I have hundreds of cells each with different series of numbers all with a 1-2 or 3 diget % and two numbers in (). I want to delete the number in parenthesis and the parenthesis. I can do it cell by cell but I figure that there should be some way to reformat the cells to do it in mass |
Excel deleting some numbers from an excel document
=LEFT(A1,FIND("%",A1))
-- Kind regards, Niek Otten Microsoft MVP - Excel "Seth" wrote in message ... |I have a spread sheet that has (example) numbers in a cell 45% (5/11) in a | cell or 60% (60/100) in a cell. I have hundreds of cells each with different | series of numbers all with a 1-2 or 3 diget % and two numbers in (). I want | to delete the number in parenthesis and the parenthesis. I can do it cell by | cell but I figure that there should be some way to reformat the cells to do | it in mass |
All times are GMT +1. The time now is 03:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com