I have copied over some data from a website into excel which is made up of 2 columns and a few thousand rows
within the rows of data are randomly placed costs which i would like to filter out, they all all a £ sign in front of them.
I was hoping to be able to do a custom filter to filter these out, however excel doesn't seem to recognise that this £ sign is there.
I am unable to simple filter on numbers as there are other values within these rows which are not costs, the only factor that identifies the costs is the £ sign.
If i click in one of the cells it just shows the number in the edit bar but not the £ sign
Is there a way of making this £ sign active and therefore filter able
Thanks
within the rows of data are randomly placed costs which i would like to filter out, they all all a £ sign in front of them.
I was hoping to be able to do a custom filter to filter these out, however excel doesn't seem to recognise that this £ sign is there.
I am unable to simple filter on numbers as there are other values within these rows which are not costs, the only factor that identifies the costs is the £ sign.
If i click in one of the cells it just shows the number in the edit bar but not the £ sign
Is there a way of making this £ sign active and therefore filter able
Thanks