Separate characters and digits

dszl136154 · May 2, 2012 9:18AM

Is there any formula which separates characters and digits? Eg.
SE13 => SE 5
A14 => A 14
S5 => S 5

chris · May 2, 2012 10:09AM

Hi,

Do you want to create a separate field with a space between the characters and the digits?

dszl136154 · May 2, 2012 10:17AM

I would like to have it in two sepearate fields: 1.Characters 2.Digits

chris · May 2, 2012 10:21AM

The following formula will show only the characters:

LEFT([PCode], SEARCHREGEX("\\d", [PCode], 1) - 1)

The following formula will show the digits:

RIGHT([PCode], SEARCHREGEX("\\d", [PCode], 1) -1)

dszl136154 · May 2, 2012 10:23AM

Thanks

Welcome!

Categories

Ideas Parade