Chat GPT & Generative AI tools

[Rich1950]

Hi sniffer66

That was my point

But it works

Rich1950

[sniffer66]

Hi sniffer66

That was my point

But it works

Rich1950

I just re-read it. I missed that bit lol

[conduirez]

If the text "Arsenal v Levercusen" has a "v" within "Levercusen," and you want to split it into two columns at the first occurrence of "v," you can use a formula in Excel. Assuming your data is in cell A1, you can use the following formulas:

For the "Arsenal" part (in cell B1):
```excel
=LEFT(A1, SEARCH(" v", A1) - 1)
```

For the "Levercusen" part (in cell C1):aa
```excel
=MID(A1, SEARCH(" v", A1) + 2, LEN(A1))
```
Rich1950

Hi Rich

I know this is about AI but there is a brilliant cell formula which will work on newer versions of Excel, called TEXTSPLIT which may help some people.

Instead of using LEFT and MID in scenarios like above, use TEXTSPLIT instead you have your text, "Arsenal v Levercusen"in cell A1, so in cell B1 you would insert
=TEXTSPLIT(A1," v ")
This will automatically put "Arsenal" in cell B1 and "Levercusen" in cell C1.

[jimibt]

If the text "Arsenal v Levercusen" has a "v" within "Levercusen," and you want to split it into two columns at the first occurrence of "v," you can use a formula in Excel. Assuming your data is in cell A1, you can use the following formulas:

For the "Arsenal" part (in cell B1):
```excel
=LEFT(A1, SEARCH(" v", A1) - 1)
```

For the "Levercusen" part (in cell C1):aa
```excel
=MID(A1, SEARCH(" v", A1) + 2, LEN(A1))
```
Rich1950

Hi Rich

I know this is about AI but there is a brilliant cell formula which will work on newer versions of Excel, called TEXTSPLIT which may help some people.

Instead of using LEFT and MID in scenarios like above, use TEXTSPLIT instead you have your text, "Arsenal v Levercusen"in cell A1, so in cell B1 you would insert
=TEXTSPLIT(A1," v ")
This will automatically put "Arsenal" in cell B1 and "Levercusen" in cell C1.

yup that would work. and a small extra: =PROPER(TEXTSPLIT(LOWER(A1)," v "))

this would take a value of "Arsenal V Levercusen" and split it irrespective of case and then convert the team names to proper case...

[Trader724]

[Rich1950]

Hi sniffer66, conduirez, Trader724 and jimibt,

Nothing artificial about your intelligence.

Rich1950

[Kai]

Hi sniffer66, conduirez, Trader724 and jimibt,

Nothing artificial about your intelligence.

Rich1950

It's going to get really awkward when AI finally reveals that we are essentially AI ourselves

[Euler]

AI celebrating Christmas

[Trader724]

OIG.jpeg

[Kai]

That's a much nicer purpose than I've seen this feature being used for!

[Fugazi]

That's a much nicer purpose than I've seen this feature being used for!

[sibur]

Be good if it could generate BAF automations

[Fugazi]

Be good if it could generate BAF automations

I've found it can help. I explain what I want it to do, then a bit of back and forth while I explain to it what some of my drop down options are when I need a more step by step approach

[paspuggie48]

AI celebrating Christmas

Sorry if you have already mentioned it Peter but which AI tool are you using for your graphic generator?

[paspuggie48]

Hi sniffer66

That was my point

But it works

Rich1950

Lots of new functions in Excel like Textsplit are great for one off things. Textjoin is another

Would be much easier with PQ but you probably know I would say that.

As per what Sniffer said, I use the "space v space" as a delimiter. In fact one can write whatever one wants in the open text field.

Here is a list of games exported from Guardian.

spaceVspace.PNG

One can use the Split Column function in the Power Query Editor

spaceVspace delimiter.PNG

The outcome being something like this : -

spaceVspace split.PNG

There are other options like text before or after delimiter, ranges, number of characters. There so many options and as I have mentioned before it requires no formulas at all.

Just saying...