Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T De Villiers
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove varying amounts of space characters Access Joe Excel Discussion (Misc queries) 4 January 13th 06 11:28 PM
read characters starting from the right until a space is reached wolfpack95 Excel Discussion (Misc queries) 5 January 4th 06 08:46 PM
Help - Can't directly input Japanese characters into cell NKK Excel Discussion (Misc queries) 0 January 3rd 06 03:00 AM
Don't allow a space in a cell...how to prevent? Jugglertwo Excel Discussion (Misc queries) 2 December 2nd 05 05:50 PM
formula that will go up one space if no value in specified space skammi Excel Worksheet Functions 1 November 16th 05 04:28 PM


All times are GMT +1. The time now is 06:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"