How to split a string into a new string

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 ‘-’

Capture

I’m using:

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

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

Thanks!

Hi there! Try this formula :slight_smile:

LEFT({Full name eng}, FIND(" ", {Full name eng}) - 1) & MID({Full name eng}, FIND(" ", {Full name eng}) + 1, 1)
3 Likes