cHARACTERS BEFORE THE SPACE
 

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

cHARACTERS BEFORE THE SPACE
 

=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

cHARACTERS BEFORE THE SPACE
 

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

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

"T De Villiers"
wrote in message
news:T.De.Villiers.21u70c_1137598505.5848@excelfor um-nospam.com...

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

cHARACTERS BEFORE THE SPACE
 

DataText to ColumnsDelimited by spaceNext.

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
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