I need a Name text..

[BHUVANESH]

I have a column [name]=rohitan abcd@gmail.com

I need only rohitan text...

I don't need email ...

please anyone tell me..

[Steve]

I have no idea what you're asking. Perhaps ask in your native language?

[BHUVANESH]

I have a column name column.

[name]=rohitan abcd@gmail.com

I need only rohitan text...in Virtual column..

I don't need email ...

I Need [Name virtual column]= rohitan

[Marc_Dillon]

https://help.appsheet.com/en/articles/2357340-split

https://help.appsheet.com/en/articles/2357278-index

[Swoopy · Accepted solution]

Have you tried this?

LEFT([name],
   FIND(" ", [name]) - 1
)

Assume that,

-there's a space between name and email ALWAYS.

-NO additional space within name.

BTW I would suggest using format like

Rohitan MiddleName LastName,abcd@gmail.com

or

Rohitan MiddleName LastName, abcd@gmail.com

or

Rohitan MiddleName LastName , abcd@gmail.com

then use,

TRIM(LEFT([name],
   FIND(",", [name]) - 1
))

to get "Rohitan MiddleName LastName"