| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove punctuation mark, Split cells & average accross column
I have data in column like this.
50 50/152 [Blank] 56 150/150 20 [Blank] I want only single numerical or blank in cell. For that I need average of 50/152. I am using formula =(LEFT(A1, FIND("/",A1)-1) + MID(A1, FIND("/",A1)+1, 100)) / 2 for that. But How can I use it with IF so that I can apply to whole column? Question is - To remove punctuation mark from data & make it clean. Than keep only single numerical digit. What to do if there is any other punctuation mark in cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove punctuation mark ' | Excel Programming | |||
| Linking Cells accross Workbooks using Column Names | Excel Discussion (Misc queries) | |||
| remove punctuation from address | New Users to Excel | |||
| Remove Punctuation? | Excel Worksheet Functions | |||
| Remove green mark upper left several cells Excel? | Excel Worksheet Functions | |||
Threaded Mode
