Extract Words from Cells

[Celticshadow]

Hi All

I seem to have run into a few problems in the last few days and hopefully this will be my last request for a while. What I would like to do is extract the words from one cell and place them in another as shown below.

Thanks in advance.

Kind Regards

[RANGE=cls:xl2bb-100][XR][XH=cs:3]Excel Workbook[/XH][/XR][XR][XH][/XH][XH]A[/XH][XH]B[/XH][/XR][XR][XH]1[/XH][XD=h:c]Data[/XD][XD=h:c]Result Required[/XD][/XR][XR][XH]2[/XH][XD=h:c]Benedict Spirit 12p[/XD][XD=h:c]Benedict Spirit[/XD][/XR][XR][XH]3[/XH][XD=h:c]Cloneen Storm 43P t[/XD][XD=h:c]Cloneen Storm[/XD][/XR][XR][XH]4[/XH][XD=h:c]Commandment 14[/XD][XD=h:c]Commandment[/XD][/XR][XR][XH]5[/XH][XD=h:c]Coursey Rover 42P t[/XD][XD=h:c]Coursey Rover[/XD][/XR][XR][XH]6[/XH][XD=h:c]Dangan Bridge 42P[/XD][XD=h:c]Dangan Bridge[/XD][/XR][XR][XH]7[/XH][XD=h:c]Hazeymm 14[/XD][XD=h:c]Hazeymm[/XD][/XR][XR][XH]8[/XH][XD=h:c]Hes A Magpie 16 p[/XD][XD=h:c]Hes A Magpie[/XD][/XR][XR][XH]9[/XH][XD=h:c]Knockmoy Jewel 42P[/XD][XD=h:c]Knockmoy Jewel[/XD][/XR][XR][XH]10[/XH][XD=h:c]Page One Two Nine 81[/XD][XD=h:c]Page One Two Nine[/XD][/XR][XR][XH]11[/XH][XD=h:c]Paradis De Thaix 93[/XD][XD=h:c]Paradis De Thaix[/XD][/XR][XR][XH]12[/XH][XD=h:c]River DOr 85[/XD][XD=h:c]River DOr[/XD][/XR][XR][XH]13[/XH][XD=h:c]Rock County 71[/XD][XD=h:c]Rock County[/XD][/XR][XR][XH]14[/XH][XD=h:c]Rokococo Palm 37[/XD][XD=h:c]Rokococo Palm[/XD][/XR][XR][XH]15[/XH][XD=h:c]Stylos Ace 16 b[/XD][XD=h:c]Stylos Ace[/XD][/XR][XR][XH]16[/XH][XD=h:c]Vital Plot 16 t[/XD][XD=h:c]Vital Plot[/XD][/XR][XR][XH]17[/XH][XD=h:l]I need to extract the word or words before the numbers and place them in column B.[/XD][XD][/XD][/XR][XR][XH]18[/XH][XD][/XD][XD][/XD][/XR][XR][XH]19[/XH][XD][/XD][XD][/XD][/XR][XR][XH=cs:3][RANGE][XR][XD]...[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]

 

[T. Valko]

I know the OP's example data did not show this condition, but your formula will return the wrong result if there is no space before the number... I meant to mention that in my original message. Actually, I remember typing that originally, but then I changed the wording of my message before sending it and it appears I forgot to re-include that part... sorry for the confusion that caused.

The formula I suggested does what the OP asked for based on the sample data they posted.