Exporting info from a cell

F

Flint

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?
 
J

JE McGimpsey

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))
 
Top