Trying to extract variable length text from cells.

[Davebro]

Trying to extract the two text names to columns B & C

2.00 Space Tourist 4.50 Cash The Cheque
2.38 Arctic Ambition 4.00 Sheephaven Flyer
2.50 Ocean Baroque 4.20 King Cuan
3.00 Snowcapped 4.33 Impact Warrior
3.50 Rathnaleen Kal 6.00 Atimetodream
2.10 Mashadi 4.50 Succession
2.88 Veil Of Shadows 5.50 Araminta
2.00 Dream Composer 5.00 Lihou

 

[DanteAmor]

If the numbers are 1 integer and 2 decimals.
Try:

Dante Amor
	A	B	C
1	2.00 Space Tourist 4.50 Cash The Cheque	Space Tourist	Cash The Cheque
2	2.38 Arctic Ambition 4.00 Sheephaven Flyer	Arctic Ambition	Sheephaven Flyer
3	2.50 Ocean Baroque 4.20 King Cuan	Ocean Baroque	King Cuan
4	3.00 Snowcapped 4.33 Impact Warrior	Snowcapped	Impact Warrior
5	3.50 Rathnaleen Kal 6.00 Atimetodream	Rathnaleen Kal	Atimetodream
6	2.10 Mashadi 4.50 Succession	Mashadi	Succession
7	2.88 Veil Of Shadows 5.50 Araminta	Veil Of Shadows	Araminta
8	2.00 Dream Composer 5.00 Lihou	Dream Composer	Lihou
Hoja3

Cell Formulas
Range	Formula
B1:B8	B1	=MID(A1,6,SEARCH(" ?.",A1,6)-6)
C1:C8	C1	=MID(A1,SEARCH(".",A1,5)+4,99)

 

[Ruddles]

Just using Excel formulae, if your text is in A1:-

In B1: =MID(A1,6,FIND(".",MID(A1,6,255))-2)
In C1: =MID(A1,FIND(".",MID(A1,6,255))+9,255)

Then copy down.

Does that work for you?

It assumes all the numbers are in the format n.nn and there are no superfluous spaces.

Let me know?