• ## Other - General

### Forum Guide

by Published on 2016-11-07 12:48 AM

Getting the Most From Excelguru Forums
We take a lot of pride in providing good help, and really want our users to walk away with an answer to every question.

How the Forum Works

Using the Forum
Step 1 – Register, Activate Your Account and Log In
Before you can post a question, you must register and log into the forum. This is generally a 3-step process:

1. Register
2. Activate
3. Login

If you haven’t already done so, you need to register for an account by visiting our forum registration page. Fill out the form and click on the white “Complete Registration” button.

Once you’ve submitted your registration, you will receive a confirmation email from (webmaster)@excelguru.ca. Inside that email is an activation link. Please click it to confirm ...
• ### Recent Forum Posts

#### Data type changed to ANY after Table.ReplaceValue

You have some good videos Marcel.
An excellent resource. ...

Rudi Today, 05:29 AM

#### Data type changed to ANY after Table.ReplaceValue

Not really more informed, but I have a video basically confirming Rudi's solution.

I actually published 3 videos in a short play list about...

MarcelBeug Yesterday, 10:13 PM

#### Extracting Text/Month

Humble apologies - I missed a letter from the array. Below s a correction :

Try this formula in C2, copied down:
=MID(A2,MIN(FIND({"A","D","F","J","M","N","O","S"},A2&"ADFJMNOS")),3)...

Hercules1946 Yesterday, 06:52 PM

#### School Teacher Needs Help!!

Take a look at the attached. Does that work for you ?...

Hercules1946 Yesterday, 06:39 PM

#### Extracting Text/Month

@Azumi

Unless I'm mistaken, there is a requirement to return the FIRST instance of a three character month from the string in column A, which...

Hercules1946 Yesterday, 05:54 PM