How to separate the following

[SHABZO1]

[pre]

MIESQUES BALLOT A T  10 60.0kg (58)
SHADOWS IN THE SKY A  8 60.0kg

[/pre]

in the first i want "MIESQUES BALLOT"

IN THE SECOND I WANT "SHADOWS IN THE SKY"

OR IF I CAN GET ALL SEPARATED AND THEN I CAN DO A TEXT TO COLUMN

 

[amrit1186]

Hi Shabzo


The requirements mentioned by you are not clear. Could you please share the sample data so we can help you.


Amritansh

 

[shrivallabha]

Hi Shabzo1,


Welcome to Chandoo.org.


What Amritansh has said is correct as sometimes the samples posted here on the forum doesn't "completely" represent all situations.


But based on posted information.

Assuming that your data is in A1 then in empty cell write following formula:

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

then copy down.

 

[sgmpatnaik]

@shabz01


HI


Try This Formula


if your data in A1 as


MIESQUES BALLOT A T 10 60.0kg (58)


write the formula in b1 as


=TRIM(LEFT(A1,15))


OR


=LEFT(A1,15)


Number Specified mean from starting point to ending point including the space


for ex


MIESQUES BALLOT

123456789012345 = 15


Hope it will solve your problem


Thanks


SP