To: Brian and Johnny Thank you. You solved my problem.
There are few people who can communicate as well as you. It is extremely difficult to get into the readers mind so that just one small piece of information is not left out. I noticed that there are some Users who gave up using OOo which is probably because no one was able to give them an answer that had all the pieces included and was in the words that the reader understood. There may be Rows in Calc but I may be Rowing my boat Walter Denver Colorado On Sat, Oct 3, 2009 at 10:47 AM, Johnny Rosenberg <[email protected]>wrote: > 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] > >
