Picking values out

[Guest]

Hi,

I am looking to be able to have a cell that will pick a value/s from a cell
next to it.

example....

In the cells here I could have any instructions of things to do
RowA starting with Cell A2
School Run 8.45am *5234443*
DHT *5234444*
Beware of Dog *5234445*
*5234446* Fit Part

I want to pick out all the values starting with *5 from the column A. How is
this possible as the user can type all different information in this field. I
have tried the Left, Mid, & Right functions but this would not pick all up as
the may not be in these postions.

Any Ideas, as I am stuck.

Regards,
Jez

 

[Bondi]

Hi Jez,

Try this one:

=MID(A2,FIND("*",A2,1)+1,FIND("*",A2,FIND("*",A2,1)+1)-FIND("*",A2,1)-1)

Regards,
Bondie