How to delete unwanted text

[jewellove]

I have list of names with different number of character so if I want to get the first name, the =LEFT(B2;4) does not work and so as = Right(B2;5) for last name.

Mohd Abdul bin Najib return should be Mohd
Fatima binti Nor return should be Fatima
Tan Mae Ling return should be Tan
Mohd Ali Nazak return should be Mohd
Md Najib Zaad return should be Md.



Thank you.

[dogberry]

Hi

Have you tried text to columns using space as your seperator.


Chris

[jewellove]

It works.. Thank you..

[dogberry]

Hi

Pleased to help thanks for the rep and dont forget to mark your thread as solved


Chris

[Kevin UK]

Hi jewellove

Assuming your data is in column A try in A1 & copy down: =LEFT(A1,FIND(" ",A1)-1)

[icestationzbra]

if you have "Mohd Abdul bin Najib" in cell A1:

this will give you the first name "Mohd",

Please Login or Register  to view this content.

and this will give you the last name "Najib",

Please Login or Register  to view this content.

assumption is that 255 is the maximum length of any name in your data; you can change it to a different number if you need to.

or,

Please Login or Register  to view this content.

or,

Please Login or Register  to view this content.

[Kevin UK]

@ icestationzbra

=LEFT(A1,FIND(" ",A1))

You might need to wrap in TRIM as you will have a extra character.