2009/10/3 Brian Barker <[email protected]>: > At 13:22 02/10/2009 -0600, Walter Hildebrandt wrote: >> >> Column A in the spreadsheet is column LC. Column B in the spreadsheet is >> column LE. Column C in the spreadsheet is LF. >> >> The following formula was put into cell LF1 >> =IF(ISNA(VLOOKUP(LC1;$LE$1:$LE$12;1;0));"";VLOOKUP(LC1;$LE$1:$LE$12;1;0)) >> >> The same word was in cells LC1 and LE1 and that word appeared in cell LF1 >> >> I clicked on cell LF1 to select (highlight) that cell and pressed Ctrl+LF > > Er, not quite right! You were recommended to use Ctrl+C - which is the > keyboard shortcut for copying the currently selected cell. You could then > use Ctrl+V, as suggested, to paste (modified) copies into other cells in > your results column. The "C" here is for "copy", of course - nothing to do > with the results column in the example being column C. You seem to have > thought that since your actual results column is LF, you should modify this > keystroke to "Ctrl+LF". Er, no.
I was actually thinking ”what does he mean by ”Ctrl+LF”. One thought was that LF=LineFeed, but I was still confused, of course. I should have realized that my suggestion was misunderstood, but for some reason I didn't. > >> The Find & Replace dialog box appeared. > > Well, it would. Ctrl+L,F is Ctrl+L followed by Ctrl+F. First, Ctrl+L > aligns left (but that is the default for text, so you probably didn't see > anything happen), and then Ctrl+F is indeed the shortcut for Find & Replace. > >> Various entries were made in the dialog box but none of them worked. What >> is being done wrong? > > That wasn't part of the suggested technique. > > Brian Barker Thanks Brian, for clarifying. Hopefully this will solve Walter's problems with my suggestion. J.R. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
