Libra Calc: how to change all in 3,200 cells in one row all at once

[BFC]

I have 3,200 phone #s like this (999)999-9999 what I need is 19999999999 in all cells. Any way to edit all cells at once? instead of 3,200 plus edits? Thanks

[charlie.it]

Find & replace with 3 steps:

1. Find “(” > Replace “1”

2. Find “)” > Replace “” (no characters)

3. Find “-” > Replace “” (no characters)

If my answer helped you, vote it with and with ∧ (here on the left)

[PYS]

Hi

I think we can do just one replacement

• Search For: \((.{3})\)(.{3})-(.{4})
• Replace with: 1$1$2$3
• Other Options: check Regular expressions & if necessary Current selection only

Explanations:

• We look for a ( followed by 3 characters followed by ) followed by 3 characters followed by a - and then 4 characters
• We put the characters expressions in parentheses e.g. (.{3})
• ( ) are used to group terms
• Groups are defined as references that can be used in the Replace zone: $3 refers to (.{4}), it is the third parenthetical group

Regards