Hey,

I’ve got a ‘Full name’ cell, I want to separate the full name to First name + one letter from the family name.

for example:

Mark Zuckerberg -> MarkZ (with no space)

How can I do that?

I’ve try something like this, but I can’t get ride from the ‘-’

I’m using:

Blockquote

SUBSTITUTE({Full name eng}, " ", “-”)

Blockquote

LEFT(TRIM, SEARCH("-", TRIM)+1)

Thanks!