Mid function question

[silverxx12]

Hi

i am trying to extract the text after and including the "@" sign in the following text string:

Burger Deal @ £8.50

i am using =MID(C14,FIND("@",C14),7)+0

but the formula is returnind #value for some reason any suggestions plz

thnx?

 

[VoG]

Try removing the +0 from the end.

 

[silverxx12]

yup that worked - what does the +0 do again ?

 

[VoG]

If you were trying to extract 8.50 from that string then +0 would coerce that from text into a number.

As @ £8.50 cannot be coerced into a number, your formula was returning an error.
<table style="width: 64px; height: 20px;" border="0" cellpadding="0" cellspacing="0"><col width="64"><tr height="20"> <td style="height: 15pt; width: 48pt;" height="20" width="64"> </td> </tr></table>