Try: Select whole column Edit -> find&replace enter in "search for" : [0-9]+,[0-9]+, Leave "replace with" blank Click "other options" mark "regular expressions"
click "replace all" The reg expression above expects at least 1 digit before the first comma and between the commas. If this is not the case (the value can also be ..Text), then replace the "+" with "*" in above regular expression Success, Rob. On 5 okt. 2015, at 08:54, Pat Brown wrote: > I have over 2000 records in a sheet. At the beginning of each record there > is a series of numerals. I want to do a Find & Replace to remove these > numerical values but I cannot seem to find the right formula. The leading > numerals are not of consistent length, example > 1,1,Guide > 1,24,Field > 1,225,The Music > The format is consistent in each case, just the length differs > Any suggestions? > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
