Timeline for Find or conditional format a column of phone numbers NOT in desired format
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 6, 2021 at 9:43 | comment | added | marikamitsos | Seasons greetings @Genny No worries. The only difference is that my formula takes into account the fact that data column can also have letters down the line while Erick's formula does not. | |
| Jan 6, 2021 at 2:35 | vote | accept | Genny | ||
| Jan 6, 2021 at 2:36 | |||||
| Jan 6, 2021 at 2:34 | comment | added | Genny | Hey @marikamitsos Thank you so much again for your help! It works like magic! I'm on the fence about whether to mark you or Erik as the correct answer, because both your formulas work. | |
| Jan 5, 2021 at 16:33 | comment | added | marikamitsos | Seasons greetings @ErikTyler You were right. I had written a testing formula instead of my final one. It is now fixed. | |
| Jan 5, 2021 at 16:31 | history | edited | marikamitsos | CC BY-SA 4.0 |
added 2 characters in body
|
| Jan 5, 2021 at 16:09 | comment | added | Erik Tyler | you and I had similar thinking; however, your rule would fail to flag entries like "10425 689 5967" that contain the desired pattern without being limited to only that pattern because you don't have the startofstring and endofstring markers. I'd recommend adding those. | |
| Jan 5, 2021 at 15:59 | history | answered | marikamitsos | CC BY-SA 4.0 |