Text & Number in a cell A -> Ouput Text in cell B

[Uexkuel]

Hello community,

right now I try to find a way or a formula which seperates the text from the Text&Number.
Left() and right() do not work becuase the format is different.

I have around 15000 entries which different formats, such as:

45736-EN
234-US-I
4523382-FR
EN-345432

Is just need a formula which outputs me the text, do you have any ideas to do it?

Regards,
Uexkuel

[pjwhitfield]

There are probably ways to do it with a formula but heres a quick Function that returns what you want:

Please Login or Register  to view this content.

[bmouse]

Do all entries have the "-" between text and number? If so you can use Text to Columns and input "-" as a separator to output the data in separate columns.