UDF Function for Split Left & right

[santosh226001]

Hello Team

We want a 2 function for Split our text First Name & last Name seperated by " "

We know we use formula but if u forum expert/guru provide me a UDF so my work will be very help full

we have may sheet so macro can't work....

data like following..

Ramesh Singh
Rakesh Singh
Suresh Kumar


We want split this data in 2 coloum

thanks in advance

[popipipo]

=LEFT(A1,FIND(" ";A1,1)-1)
=RIGHT(A1,FIND(" ";A1,1)-2)

Use these 2 formulas

[AlKey]

Or you can simply use Text to Column feature in Excel and choose space as delimiter.