Both ways worked perfectly, but in =MID(B2,2,SEARCH(" ",B2)-2) i had to put
=MID(B2,1,SEARCH(" ",B2)-1) in order to give me full word.
Thank you both, very much for your help. :), excel-lent as always!
2011/3/24 Ms-Exl-Learner .
> Try this…
>
>
> =IF(ISNUMBER(FIND(" ",TRIM(B2))),LEFT(TRIM(B2),F
Try this…
=IF(ISNUMBER(FIND(" ",TRIM(B2))),LEFT(TRIM(B2),FIND("
",TRIM(B2))),IF(LEN(TRIM(B2))<>0,B2,""))
---
Ms.Exl.Learner
---
On Thu, Mar 24, 2011 at 4:20 AM, Jorge Marques wrote:
> Hi guys, is there any way i can do to for example if a cell B2 has th
Hi Jorge,
You can use the following formula to get the desired output:-
=MID(B2,2,SEARCH(" ",B2)-2)
Best Regards,
DILIPandey
On 3/24/11, Jorge Marques wrote:
> Hi guys, is there any way i can do to for example if a cell B2 has the
> following text "phillips LCD 32"" it returns philips to cell B
Hi guys, is there any way i can do to for example if a cell B2 has the
following text "phillips LCD 32"" it returns philips to cell B1 but without
extracting the character on the left, because if it gives me a OEM brand, i
have to put the information corresponding by vendor and not brand. thx
--
