0
votes
0answers
28 views

Excel String compare [duplicate]

I am trying to compare string and then display the what doesn't match between the two of them, for example: take A1 which contains [alpha:beta] and then B1 which contains [alpha] and it will match ...
0
votes
3answers
64 views

How can I get the string of a cell?

I have a list of around 20 items and the user can pick three of them to perform a comparison, so I need a formula which gets the "TRUE" and gives me the contents of the correspondent cell in the same ...
0
votes
2answers
54 views

MS Excel: is 'ABCD always exactly the same as =“ABCD” in a cell?

As described in the title, is 'ABCD always exactly the same as ="ABCD" in a cell? It says that all the characters after the beginning apostrophe will be treated as string, so does that essentially ...
0
votes
1answer
167 views

How do I populate a column with the first x characters of text data in another column

I have a column with 14 characters. There is real information based on the first three characters. I want to have another column with only the first three characters for visibility and group by ...
2
votes
1answer
4k views

Can I force an Excel 2010 Pivot-Table to display text strings from my raw data?

Here is my use-case. As a training specialist I want to look at a single tab in Excel and see student feedback at a glance. I want to see pie-charts showing who said "Yes" this course was a good use ...
2
votes
3answers
2k views

Excel CSV import treating quoted strings of numbers as numeric values, not strings

I've got a web application that is exporting its data to a CSV file. Here's one example row of the CSV file in question: 28,"65154",02/21/2013 00:00,"false","0316295","8316012,8315844","MALE" ...
0
votes
1answer
2k views

returning string from vlookup in excel

I am having trouble with the vlookup function in excel. I have 2 files: file1.xlsx and file2.xlsx. Both files have a list of products with a number of various information and I need to add values ...
0
votes
3answers
226 views

How to manipulate this string of text to make it readable?

I have this string in an excel file: 4603,2504603#;4616,2504616#;4617,2504617#;4519,2504519#;4620,2504620 (It's actually a lot longer than that, but the pattern is the same). I need to be able ...
0
votes
3answers
741 views

EXCEL: IF value for multiple cells

I have a 3 columns, some of which have countries in them like so I J K -------------- ----------------- ---------------- Denmark Finland ...
0
votes
1answer
229 views

Excel: How can I replace a short string of characters with one character?

So, I keep a spreadsheet of all of my bowling scores and how I do on each frame. To show that I got a split, I use "#s", where # is how many pins I knocked over, but I want to replace all of these ...
1
vote
2answers
20k views

Excel extract substring from string

I am looking for a way to extract a variable length substring from a string. My cells will look something like: ABC - DEF ABCDE - DEF ABCD - ABC I want to split the string at the - character, so ...
2
votes
1answer
511 views

Formatting a tab-delimited CSV/TSV to force Excel to interpret value as a string

I had a followup question to this related post - Formatting a CSV to force Excel to interpret value as a string (not date or number) I was wondering how does one escape text starting with " using ...
11
votes
5answers
12k views

Formatting a comma-delimited CSV to force Excel to interpret value as a string

Searching around for a while trying to figure out how to format a CSV file in such a way to force Excel to interpret the values as a string and not try and convert them to numbers or dates. e.g... ...
5
votes
4answers
11k views

Excel Cell Length Limit

Excel is refusing to open some of the files I programmaticaly create. I think what is happening is that it pukes because a particular column has very long strings (up to 1850 chars), but for the ...
2
votes
2answers
790 views

Find more than one string with Excel?

How to Find more than one string with Microsoft Office Excel? For example, I am looking for the cells which is contained both strings Paul and John? How to avoid to perform several finds by ...
3
votes
3answers
20k views

Any Excel function that will reverse a string?

Are there any built-in Excel functions that will reverse a string?
13
votes
3answers
66k views

Excel: Replace occurences of one character with another in a String?

I want an excel formula that will change Haverford, PA to haverford,+pa. (Text is to lowercase, and spaces are replaced with plus characters.) The following will get the first space, but not all of ...