MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### is 3rd character in a cell a space?

• Follow

```Looking for a way to determine if the 3rd character in a cell is a
space.  (Dealing with mailing lists; trying to isolate values which
are first initial-period- "space" last name.
Thank you for your thoughts.
Rick
```
 0
Reply Rick 12/21/2009 7:06:17 PM

```Hi Rick,

=IF(MID(E26,3,1)=" ","Y","N")

HTH
Regards,
Howard

"Rick" <rickyhalding@gmail.com> wrote in message
> Looking for a way to determine if the 3rd character in a cell is a
> space.  (Dealing with mailing lists; trying to isolate values which
> are first initial-period- "space" last name.
> Thank you for your thoughts.
> Rick

```
 0
Reply L 12/21/2009 7:16:59 PM

```Try this:

=3DIF(MID(A1,3,1)=3D" ","Yes","No")

Hope this helps.

Pete

On Dec 21, 7:06=A0pm, Rick <rickyhald...@gmail.com> wrote:
> Looking for a way to determine if the 3rd character in a cell is a
> space. =A0(Dealing with mailing lists; trying to isolate values which
> are first initial-period- "space" last name.
> Thank you for your thoughts.
> Rick

```
 0
Reply Pete_UK 12/21/2009 7:17:18 PM

```Hi Rick

See if this can help:

=If(Mid(A1,3,1)=" ","Space","No Space")

Regards,
Per

"Rick" <rickyhalding@gmail.com> skrev i meddelelsen
> Looking for a way to determine if the 3rd character in a cell is a
> space.  (Dealing with mailing lists; trying to isolate values which
> are first initial-period- "space" last name.
> Thank you for your thoughts.
> Rick

```
 0
Reply Per 12/21/2009 7:18:49 PM

```This will return either TRUE or FALSE:

=MID(A1,3,1)=CHAR(32)

CHAR(32) is the standard space character.

--
Biff
Microsoft Excel MVP

"Rick" <rickyhalding@gmail.com> wrote in message
> Looking for a way to determine if the 3rd character in a cell is a
> space.  (Dealing with mailing lists; trying to isolate values which
> are first initial-period- "space" last name.
> Thank you for your thoughts.
> Rick

```
 0
Reply T 12/21/2009 7:20:13 PM

```On Dec 21, 1:18=A0pm, "Per Jessen" <per.jes...@mail.dk> wrote:
> Hi Rick
>
> See if this can help:
>
> =3DIf(Mid(A1,3,1)=3D" ","Space","No Space")
>
> Regards,
> Per
>
> "Rick" <rickyhald...@gmail.com> skrev i meddelelsennews:c1ec1b82-8ddb-461=
>
>
>
> > Looking for a way to determine if the 3rd character in a cell is a
> > space. =A0(Dealing with mailing lists; trying to isolate values which
> > are first initial-period- "space" last name.
> > Thank you for your thoughts.
> > Rick- Hide quoted text -
>
> - Show quoted text -

Ya'll are great!
Rick
```
 0
Reply Rick 12/21/2009 7:22:51 PM

5 Replies
237 Views

(page loaded in 0.129 seconds)