Formula to extract data from the middle of a cell.

**SEMMatt** · 11-21-2011, 05:43 PM

Hello,

I need to extract the text contents from the middle of a data string? Is there a way to subtract both sides from each other because I can write a formula for that. The data in the middle is different for every cell but it's the similar enough on each side that I can write a formula on it.

**NBVC** · 11-21-2011, 05:44 PM

Can you supply some examples of raw data and what you want to extract?

**SEMMatt** · 11-21-2011, 05:59 PM

Originally Posted by NBVC

Can you supply some examples of raw data and what you want to extract?

Sure! So for example I have these cells

VIM_20110505_B_BreakOut_160x600_FLA_GA.swf
VIM_20110525_B_Wings_160X600_FLA_GA.swf
VIM_20110603_B_SC_Flip_160x600_FLA_GA.swf

in which case I need to see BreakOut, Wings and SC_Flip

Thanks!

**daddylonglegs** · 11-21-2011, 06:05 PM

In those examples the data you want always starts at character 16 and then runs until the next underscore, for that try this formula for data in A1

=MID(A1,16,FIND("_",A1,17)-16)

**NBVC** · 11-21-2011, 06:09 PM

I am not sure of the consistency of the data.. but I am off now.. so I will leave you with this and hopefully it works for you...

=TRIM(SUBSTITUTE(UPPER(MID(A1,16,255)),"_160X600_FLA_GA.SWF",""))

or

=LEFT(MID(A1,16,255),LEN(MID(A1,16,255))-19)

where A1 contains first original string...