On 2021-10-23 18:14, Johnny Rosenberg wrote:
Den tors 7 okt. 2021 kl 00:28 skrev T. R. Valentine :
On Tue, 5 Oct 2021 at 07:07, David Lynch wrote:
The defaults in the Find toolbar and the Find dialog are:
Direction: Rows Search in: Formulae
I normally want the opposite: Search in columns
Hi Rob, did you ever get this answered.
You could use something like the below for the cells with a '+' in them.
Assuming below is row 4, vertical bars are cell borders.
|25+15|=VALUE(LEFT(A4,FIND("+",A4)-1))+VALUE(RIGHT(A4,LEN(A4)-FIND("+",A4)))|
If you need it to be generic for with/without
Den tors 7 okt. 2021 kl 00:28 skrev T. R. Valentine :
> On Tue, 5 Oct 2021 at 07:07, David Lynch wrote:
> >
> > The defaults in the Find toolbar and the Find dialog are:
> >
> > Direction: Rows Search in: Formulae
> >
> > I normally want the opposite: Search in columns (because columns usually
>
Den lör 23 okt. 2021 kl 21:38 skrev Steve Edmonds <
steve.edmo...@ptglobal.com>:
> Hi Rob, did you ever get this answered.
>
I answered it, but unfortunately I failed (again) to send it to the group.
Sorry for that.
I'll see if I can find it and send it again, but to the group this time.
I use