Get instant live Excel expert help with Text Functions

I have a column of text with names of foundations. Some of these names appear multiple times. I only want to count the 1 time each appears. How do I do this so that I can simply say, "There are 10 foundations funding this issue" even if some of those foundations show up 3 times in the column.

Hi there, Our Company is making the switch from InfusionSoft to Hubspot. I am working on importing our contact list but it has to be formatted a certain way in order to meet Hubspot's Criteria. The First name and Last name need to be in separate columns ( in CSV) format. Half of the list exported correctly but about 2,00o contacts have the first and last name in the same box.... I have tried using Data>Text to columns but nothing is working.

Hello, Our company is in the process of switching to Hubspot from Infusion Soft. I have exported our contact list however the format is not meeting Hubspots guidelines. I need for the First name and Last name to be in separate columns. I tried data>text to columns but it didnt work.

I need to conditional format a cell to be greet if one cell says text and the other cell is within a range

Hi, I am having trouble using find and replace in my worksheet. I am trying to find and replace a string of text that is part of a larger portion of text in the cells of one column of the worksheet. The problem is that the find and replace function is replacing the entire cell contents, not the string of text specified in find and replace.

I'm trying to create a formula that combines cells, remove spaces, and adds text.

I need help with a nested if statement returning text

I recently exported a bibliography from word into excel via text. The titles, all between “ and “ have varying lengths therefore diffent columns. Using concatenate how can I make a formula that only concatenates between cells where “ appears, i.e.a concatenate formula of varying columns?

I am trying to figure out how to create a formula that will allow me to easily transfer data from ‘Text worksheet B’ to the ‘Test master’ sheet. I want the programs listed in column B of the ‘text worksheet B’ to be transferred to the columns M, N, O, etc in the ‘test master’ sheet for the corresponding person (ie person A, person B, etc). The programs should be listed in columns M,N,O, etc of the ‘test master’ sheet based on their rank in column D of the ‘text worksheet B.’ For instance, Program E for Person B in the ‘text worksheet B’ should be populated in the cell P3 on the ‘test master’ worksheet. Make sense?

insert an if function that first tests whether the value in cell b16 is equal to an empty text string. if it is, return an empty text string; otherwise, apply a lookup function to retrieve the lookup value from the table in the range f5:h8 using the value of cell b16 as the lookup value