cHARACTERS BEFORE THE SPACE

[T De Villiers]

Hi,

I need a function which does the following:

F1 FRED
F23 GHTYRFFFF
G1234 AD

becomes:
F1
F23
G1234

i.e Returns the characters before the space, many thanks

[CLR]

=LEFT(A1,FIND(" ",A1,1)-1)

Vaya con Dios,
Chuck, CABGx3



"T De Villiers" wrote:

>
> Hi,
>
> I need a function which does the following:
>
> F1 FRED
> F23 GHTYRFFFF
> G1234 AD
>
> becomes:
> F1
> F23
> G1234
>
> i.e Returns the characters before the space, many thanks
>
>
> --
> T De Villiers
> ------------------------------------------------------------------------
> T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
> View this thread: http://www.excelforum.com/showthread...hreadid=502479
>
>

[Bernard Liengme]

Try =LEFT(A1,FIND(" ",A1)-1)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"T De Villiers" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi,
>
> I need a function which does the following:
>
> F1 FRED
> F23 GHTYRFFFF
> G1234 AD
>
> becomes:
> F1
> F23
> G1234
>
> i.e Returns the characters before the space, many thanks
>
>
> --
> T De Villiers
> ------------------------------------------------------------------------
> T De Villiers's Profile:
> http://www.excelforum.com/member.php...o&userid=26479
> View this thread: http://www.excelforum.com/showthread...hreadid=502479
>

[Gord Dibben]

Data>Text to Columns>Delimited by space>Next.

Choose "do not import" after selecting column 2.


Gord Dibben MS Excel MVP

On Wed, 18 Jan 2006 09:34:32 -0600, T De Villiers
<[email protected]> wrote:

>
>Hi,
>
>I need a function which does the following:
>
>F1 FRED
>F23 GHTYRFFFF
>G1234 AD
>
>becomes:
>F1
>F23
>G1234
>
>i.e Returns the characters before the space, many thanks