phone

Hi, Is it possible to sync an excel file on the computer with an excel file on android phone? Thanks

Not an advanced Excel user at all, but trying to figure some things out. Was hoping to get some advice on my situation and hopefully come up with a solution. I have a Column that holds phone numbers in the their traditional format, (123) 456-7890 and receive a CSV report of these phone...

Hopefully this isn’t too confusing… I have two spreadsheets containing several thousand rows each and need to compare the two. The first (AV) is from our internal database and the second is from an online source (XYZ). AV contains: Name, Email, Phone, Status XYZ contains: Name, Email...

I have a long list of contact information that I'd like to sort by ones that have a phone number in the name column. An example: Bob Johnson Joe WALMART John Smith 555-555-5555 There are numerous entries but I'm trying to sort a column so I can group the entries that have a phone number like...

hi all... how to make in custom number format phone number like this (insert mark "-) e.g 0812-5265-9999 0817-6325-8743 0878-6986-410 thanks in advance.. m.susanto

Hello Folks, The Following Code is not working =IFERROR(IF(E6<>"",(INDEX(Prowatch!AI:AI,MATCH(E6,Prowatch!H:H,0))),""),"No Number Listed") So in E6 theres and email address On Prowatch Tab AI:AI is a range of email addresses IF E6 email matches anywhere in Range Match E6 Prowatch H:H which...

Here's the situation. we are moving to a new CRM (or to a single REAL CRM if you want to be honest) and we need each phone number in a new column with out the jargon (random notes) behind it. The phone number are in one column now, separated by an alt return. The phone number look like the...

Hello I want to know which is the simple vba code to color last word from a range of cells. <tbody style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; vertical-align: baseline;"> 1 John cell phone //991612 2 Maria cell phone //842246 3 Bill cell phone //892246 </tbody> i...

Good morning guys I really need your help.. I tried to find a VBA for me but i didn't, and those i found i didn't understand at all! hahaha I would like a VBA to copy 4 specific things from na e-mail, there are: "CNPJ", "E-mail", "Phone" and "Name" (CNPJ and E-mail are the most important, and...

I am not sure that I'm using the most efficient approach to what I'm trying to achieve. Input and advice is most welcome. I'm sure this is a simple formula, but I'm not having and success with it. <tbody> IF(AND( A1 > 9, and < 20, and B1 = "PHONE"), (DO THIS) </tbody> <tbody>...

I'm trying to automate taking a phone number and blanking out the first 7 digits, so 07779287640 becomes *******7640. As an additional complication the phone number needs to be stored with " at the front and back of it and sometimes there is no phone number so I'll have to return "". I have the...

Hi, I have tried several scripts (and modified them) but I seem to be missing something. I would like to export, from a specified folder in Outlook, specific body items. This is from the body: SM Form 2018-05-11 11:19 AM was submitted by Guest on 5/11/2018 11:19:03 AM (GMT-05:00) US/Eastern...

Hi, I have tried several scripts (and modified them) but I seem to be missing something. I would like to export, from a specified folder in Outlook, specific body items. This is from the body: SM Form 2018-05-11 11:19 AM was submitted by Guest on 5/11/2018 11:19:03 AM (GMT-05:00) US/Eastern...

Hello, I've run a survey using Email, Phone and Facebook. I'm combining the results into a series of pivot charts, 1 pivot chart for each question, each question has multiple answers Some of the questions have 0 responses for some of the options(no one on the phone chose option b in question...

Hi there guys, Been a while since I've been using excel and the brain is a bit rusty.... I'm Just trying to get a formula right so that if someone enters a name, the matching phone number comes up next to it... breaks down like this.. I have a column A with names and a column B of phone...

Hi Friends. I have list of customer information in excel cell ColumnA like list of 1000 customers. I want to extract all phone numbers present in each cell data. But phone numbers formats are different in each cell like 201.337.3900 or 213373900 or 1213373900 or 1(201 337-3900 or (201)...

Hi everyone! I'm currently creating a VBA that formats phone number. All numbers must follow a standard format. The scenario goes like this: In the user's selection, or highlighted part/selected part, all phone number formats will be "three numbers" "-" "three numbers" "-" "four numbers"...

Hello, First post/long time lurker! I want to visualise the amount of time a telephone Agent has been logged in, per 15 minute interval. The below example shows the time an Agent has been on the phone, went to a break and then returned on the phone. I've got about 95% of the way there with...

Hello! Duplicates. In Column F I have different numbers. The numbers are sorted ASC. I would like to have VBA script: If a number occure in column F more than once, I want to put "DOUBLE" in column "V" in according row but only for second value and so on (first must not be marked. Colors...

i have a spreadsheet with many rows that i need sorted. it looks something like what's below... (there are ~2500 companies in total) A <tbody> Company A Name Address City, State, Zip Phone Fax Email Fluff Fluff Fluff...