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
Bookmarks