Uuups, seems I missed Johnny's suggestion yesterday - stopped reading when it seemed to be a format-cell solution only to me...
Malte. Johnny Rosenberg wrote, On 09/12/10 15:56: > Den 2010-09-12 14:19:27 skrev Malte Timmermann > <malte.timmerm...@oracle.com>: > >> If you are sure it's always 10 chars long: >> >> Search: ([0-9][0-9][0-9])([0-9][0-9][0-9])([0-9][0-9][0-9][0-9]) >> Replace: $1-$2-$3 >> >> [0-9] means finding a digit >> () is for grouping, so you can use the found string in the replace >> statement >> $<n> is result of group <n> >> >> HTH, >> Malte. > > Or, if you didn't like my suggestion yesterday about > ([:digit:]{3})([:digit:]{3})([:digit:]{4}), then a mix of both suggestions > could be: > > ([0-9]{3})([0-9]{3})([0-9]{4}) > > Replace is the same in all three cases: > $1-$2-$3 > > {x} means x instances of what's to the left of it. > > So 3 digits followed by three digits followed by four digits will be > replaced by the first three digits followed by a minus sign and so on. > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org