Tagged Questions
1
vote
3answers
124 views
Counting frequency of comma-delimited tags in Excel
I have an excel spreadsheet with a list of seminars and classes that students have taken that (when abridged) looks like:
(A)___ClassName________|(B)_________Tags____________|
Astrobiology ...
0
votes
0answers
15 views
Reflection Operation of a string [duplicate]
Possible Duplicate:
Any Excel function that will reverse a string?
Using excel, for a cell with a string of characters, for example 'ABCDEFGHIJKLMNOPQRSTUVXYZ', is there an efficient method ...
1
vote
2answers
71 views
How to pass a formula as one of the arguments to CONCATENATE?
I'm using Microsoft Excel 2010 and I am trying to create a title which will be updated every time the spreadsheet is opened. I want it to say "Forecast from (today's date) until end of 2013".
So far ...
5
votes
4answers
1k views
How to create a random string of random length from the alphabet?
I want to create a random string with random length from the alphabet in Excel. For example,
"jlskdjf", "kjlk", "kljsodif", etc. How can I do that?
0
votes
1answer
202 views
Remove URL Parameter in Excel
I have a URL of the following form:
http://www.example.com/page.html?param1=asdf¶m2=asdfg¶m3=asdfgh
I want to extract the value of param2 or 3 from the URL as well as remove that ...
1
vote
2answers
2k views
How to convert a single line of Hex numbers into a multi-row Excel table?
I'm currently at some hex strings in a video game's data files. The structure is:
XX 01 YY YY (then repeats)
Where:
XX is the item's cost
01 is unknown (it won't matter)
YY YY is the item's ID.
...
1
vote
1answer
553 views
Replace cell formatting with text in Excel?
I received an Excel document that has data that looks like the following:
A B C
=========================================
1 |F:\folderName | | |
2 ...
3
votes
3answers
13k views
Any Excel function that will reverse a string?
Are there any built-in Excel functions that will reverse a string?
0
votes
2answers
262 views
Excel string extract
I have a string in a cell:
ABCDxxxxxEFGH
ABCD and EFGH are constant, xxxxx is of variable length.
I want to write an excel formula to extract xxxxx.
