Hi guys.

I've got this spreadsheet I look after for my club. That gets updated once a year. But the thing is that it requires to manually go through each of the text strings where the start and end year is and update them all by hand. As you can see doing that type of thing on a computer is ridiculous. Computers were made to automate those things.

So I was reading up on the variable ability but I cannot get anything to help. I managed to define a year as a name with a numerical value and reference it in a cell but that is it. I only see the value if use the variable alone.

As soon as I try and string together some text and stick a variable in the middle I still end up in text!

Lets's say I have a string like so:
From 2015 to 2016.

If I try and be smart and put it together I get a WYSIWYG result:
"From "+Year+" to "+Year+1

If I put an equals in front I get a #TYPE error.

I need something like the following:
("From %d to %d"; Year; Year+1)

This looks like such an obvious thing to program into a spread sheet. Variable text. But I can't figure it out! Is this another one of those obviously simple yet too complicated for Amiga program operations?

@Hypex

I don't think you can do exactly what you describe, in the way you describe it, but it does have REXX support so use a rexx script to update your sheet.

_________________
BroadBlues On Blues BroadBlues On Amiga Walker Broad

@broadblues

ON the other hand there are a set of string function in TC 3.5 so I'd be supprised if they wwere missing in TC 5


in cell A4 I put

=YEAR(TODAY()) shows as 2016


in cell A10 I put

="the year is " + TEXT($A4) shows as The year is 2016

_________________
BroadBlues On Blues BroadBlues On Amiga Walker Broad

@broadblues

Thanks Andy! You got it.

Have a banana. :

Yes I was reading all about macros and ARexx and it seemed all the commands were all over the place. Sure they are organised in sections in the guide but it makes references to other sections without a link and I found I had to look at a load of topics to find what commands there are. And after all this still haven't see how to actually call ARexx from a cell or execute an Arexx string rather.

Now just the work of converting all the strings. But now I just have to do it once. Provided they don't mess me up by exporting to Excel again.