Right and Left Function for words within a cell

Leibel S

It needs to be a Multi Select

A Rose

The below is what came up in the columns:

Address Column: 200 E Eckerson Rd New City NY 10956

City: New City NY

Address Split:

"200

E

Eckerson

Rd

New

City

NY

10956"

A Rose

@Leibel Shuchat,

Seems like we're almost there..

Can you please let me know how to include only the City?

Thank you!

Leibel S

This is what it should look like:

A Rose

Hi @Leibel Shuchat

Where am I wrong?

Thank you!

Leibel S

@A Rose

Could be you have extra spaces somewhere?

A Rose

Thank you @Leibel Shuchat for your help,

I'll definetly come back here in the future, right now I found a way to manually include all the Cities, but this is a great formula!

Thank you!