MacMusic  |  PcMusic  |  440 Software  |  440 Forums  |  440TV  |  Zicos
column
Search

How To Separate 2 Data Points From One Column Counting Digits?

Thursday January 26, 2023. 02:38 PM , from MacMost
Hi, I have the entire column B, of a document that has a combined phone number and name as such: 786-555-1212angiemore@fir.com I would like to be able to extract the Phone number to column C, and the portion of the email only to column D. All Phone numbers are 12 digits. Can you help with a script to resolve it?
Thank you in advance
the data was received from our administrator where the phone number and email were on the same line without spaces, when we imported it to the spreadsheet we were not able to separate them properly in two columns.
—–
Felix
https://macmost.com/forum-how-to-separate-2-data-points-from-one-column-counting-digits.html
News copyright owned by their original publishers | Copyright © 2004 - 2024 Zicos / 440Network
Current Date
Apr, Sat 20 - 17:22 CEST