How to copy all character till first space which begins with "RXO" data

[nur2544]

i need to copy all character till first space which begins with "RXO" data, other than cell will be blank.please check the attachment.

i am having below data in the cell (A1:A65536)

Please Login or Register  to view this content.

i want to take it out which begins with "RXO" other then cell will be blank like following (B1:B65536)

Please Login or Register  to view this content.

I will be happy if I get both Macro & formula solution.

[TMS]

=IF(LEFT(A1,3)<>"RXO","",LEFT(A1,FIND(" ",A1)-1)


Regards, TMS

[amitkr3855]

Dear Nur2544

In B2

=IF(COUNTIF($A2,"*RXO*")=1,MID(A2,1,FIND(" ",A2)-1),"")

R's
Amit Kumar
9627771750

[jraj1106]

Hi

Try this macro:

Please Login or Register  to view this content.

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[nur2544]

Dear all
@ TMShucks , your formula is working fine

@ amitkr3855, Your formula is also working

@ jraj1106 , Your macro is working great

Now i am in puzzle which one should i use !!! ha ha ha . however thanks every one for Giving your valuable time for me , you all make my task easier

[TMS]

Always good to have choices ... unless you don't like making decisions.

[amitkr3855]

Ya actually my formula is for contain RXO instead of beginwith I came to know after i posted sorry dear

Pl. try this

hope now it's working as u need

=IF(COUNTIF($A3,"RXO*")=1,MID(A3,1,FIND(" ",A3)-1),"")

[nur2544]

Hi amitkr3855, its ok boss no problem at all. I got your point, earlier I edited your formula to implement in my task. Thanks for concern regarding the same issue. Take care…