Help

How to split a string into a new string

1661 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Eliran_Cohen
4 - Data Explorer
4 - Data Explorer

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!

1 Reply 1
AlliAlosa
10 - Mercury
10 - Mercury

Hi there! Try this formula :slightly_smiling_face:

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