Search results for query: *

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...

It works to get the increment of the pic name, but it will not recognize the correct incremental hyperlink file. I have found a macro that does what I want, but I was wondering if something like you suggested was possible. Credit given for macro to whomever wrote it. I don't remember what web...

I have about 200 hyperlinks to make. The file name is is pic1.jpg, pic2.jpg, etc... is there a way to have the hyperlink automatically increment to the next pic number?

I placed the N/A there because my chart would recognize "" as a zero value. If I placed a N/A it would not. I will monkey with it some more. Thanks, My technical level in this stuff >>> "Script Baby

Yes I do get the same results. I thought it wasn't working because of the errors. I guess I will try to deal with the #nums . Thanks for all the help. I couldn't even do this before, so coodo's to progress. The n/a error is not recognized in my chart. Guess I will ask. Is there a way to...

It refuses to work. I have Column B,C,D and needs to show up in "A". I double checked the formula syntax and it doesn't seem to like it. I tried to switch the "True" and "False" result, but that didn't work. A formula is producing the #N/A values, otherwise it would result in incorrect...