Capitalisation of First word in String

[JMB_0159]

I have a listing of 2000 rows of which are Text. I have made all of the text (proper) but what I really require is that the first word to be in UPPER as this will make it easier to distinguish when viewing. I am using Excel 2013. Any help would be appreciated. James..

 

[MARK858]

Possibly something like...

=IFERROR(UPPER(LEFT(A1,FIND(" ",A1)-1))& " "&RIGHT(A1,LEN(A1)-FIND(" ",A1)),UPPER(A1))

 

[JoeMo]

Excel Workbook
	A	B
1	Some string here	SOME string here
2	Hello, some string here	HELLO, some string here
Sheet2

 

[JMB_0159]

Thanks JoeMo works a treat ..... but if there is only one word in the string it gives an error, is there any way that we can make it recognise it is only one word and still Capitalise it without the error.

 

[MARK858]

make it recognise it is only one word and still Capitalise it without the error

Did post #2 not do this?

 

[azumi]

Thanks JoeMo works a treat ..... but if there is only one word in the string it gives an error, is there any way that we can make it recognise it is only one word and still Capitalise it without the error.

Perfecting formula from @JoeMo:

=IFERROR(UPPER(LEFT(TRIM(A1),SEARCH(" ",TRIM(A1))-1))&MID(TRIM(A1),SEARCH(" ",TRIM(A1)),LEN(A1)),UPPER(A1))