Recent content by chasethewind

Thanks Judgeh59, that was exactly what I was after. Solved

That wouldn't return the correct value on some cases. I would end up with "N032^45'E on N32^45'E

I'm looking for an easy solution to add a leading zero to a text string in excel 2010. There is the text string: N5^43'W it should say N05^43'W or S6^7'E should say S06^07'E Thanks

Hello, I'm not sure where I should start. I want to import only some of the values (based on a given value) from a comma delimited text file to an Excel 2007 sheet. The reason is I have over 1.5 million rows of data and Excel can only handle a little over 1 million rows.

Excel 2007

I only leared about the function the other day. Can you use this function with a range? Like A1 through A200? I can easily use it with a few cells, but not 200. =Concatenate(A1:A200) did not work for me.

Great. Looks like it is going to work. Thank you.

I cannot figure this out. In column A 100 1001 324 542 562 And would like to place in B1 100, 1001, 324, 542, 562 Any help would be appriciated.

Fantastic! I must have been typing while you where posting. Your formulas are exactly what is needed. Thank you for helping Skip. Cory,

Patience, I will try to expain the situation differently I have 3 column with numbers in them. I want to take the column A values place them in (lets say in column D), then I want to take the values from Column B and append them to the results (values from column A) in column D, take the...

I think "Skip" helped me with formula and it works great to sort the data, but "Small" is what needs changed now. I do not know what to use to not sort from smallest to largest. =IF(ROW(Q5)>COUNT(Q$6:S$194),NA(),SMALL(IF(ISNUMBER(Q$6:S$194),Q$6:S$194,""),ROW(Q5))) Thanks

Sorry for the confusion. I have looked everywhere and cannot find a solution to my problem. This would seem like an easy task (possible already a command in Excel). No sorting. 3 4 9 23 14 8 14 32 6 9 12 15 ...

Sorry... Excel 2007

No macros either.

How do I create a sequential list from the values shown? The NA's will have generate a number as well if a condition is met elsewhere. I need to keep the NA's (just because). Thanks Cory Column A Column B Column C 3 8 6 4 14 9...