Question

Forumla help: Separate data separated by semi-colon into multiple fields?

+4

So, I have some data that looks like this: 二代目歌川広重; 1826 - September 17, 1869

I want to sparate the japanese name, at left, from the dates, at right. It’s not always Japanese, but it is always seprated by a semicolon.

Formula suggestions?

Thanks in advance!

+21

Hey! I’m on my phone right now but you could give these two fórmulas a shot.

LEFT(Name, FIND(";", Name) - 1)

TRIM(RIGHT(Name, LEN(Name) - FIND(";", Name)))

1 reply