| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting info from a cell
I am running a web query that groups the percentage information that I want
in with text (Activity: 46%), is there a way for me to puull the 46% out of that cell so I can use it in an average formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Exporting info from a cell
One way:
A1: Activity: 46% A2: =--RIGHT(A1,4) This assumes there's always aa space between the colon and the number. Else A2: =--TRIM(MID(A1,FIND(":",A1)+1,256)) In article , Flint wrote: I am running a web query that groups the percentage information that I want in with text (Activity: 46%), is there a way for me to puull the 46% out of that cell so I can use it in an average formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| if and then formula | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
Linear Mode
