software

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: www.excelforum.com/member.php...oamp;userid=26479
View this thread: www.excelforum.com/showthread...hreadid=502479=LEFT(A1,FIND(quot; quot;,A1,1)-1)

Vaya con Dios,
Chuck, CABGx3
quot;T De Villiersquot; wrote:

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

Try =LEFT(A1,FIND(quot; quot;,A1)-1)

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

quot;T De Villiersquot; gt;
wrote in message
news:T.De.Villiers.21u70c_1137598505.5848@excelfor um-nospam.com...
gt;
gt; Hi,
gt;
gt; I need a function which does the following:
gt;
gt; F1 FRED
gt; F23 GHTYRFFFF
gt; G1234 AD
gt;
gt; becomes:
gt; F1
gt; F23
gt; G1234
gt;
gt; i.e Returns the characters before the space, many thanks
gt;
gt;
gt; --
gt; T De Villiers
gt; ------------------------------------------------------------------------
gt; T De Villiers's Profile:
gt; www.excelforum.com/member.php...oamp;userid=26479
gt; View this thread: www.excelforum.com/showthread...hreadid=502479
gt;
Datagt;Text to Columnsgt;Delimited by spacegt;Next.

Choose quot;do not importquot; after selecting column 2.Gord Dibben MS Excel MVP

On Wed, 18 Jan 2006 09:34:32 -0600, T De Villiers
gt; wrote:

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