From: Amnon Wilensky on 24 Feb 2010 19:21 Hi, I am using the formula for reversing string I have got from the forum but it works on a single cell. How can use it on a multiply cells. For example: suppose I have a list of names in cells A1:A10 and I want to reverse them to cells B1:B10. Using Excel 2003, Thanks, Amnon From: Rick Rothstein on 24 Feb 2010 19:44 See this link... http://chandoo.org/wp/2009/11/19/reverse-a-list-in-excel/ -- Rick (MVP - Excel) "Amnon Wilensky" wrote in message news:uGXipBbtKHA.928(a)TK2MSFTNGP04.phx.gbl...> Hi, > I am using the formula for reversing string I have got from the forum but > it works on a single cell. How can use it on a multiply cells. > For example: suppose I have a list of names in cells A1:A10 and I want to > reverse them to cells B1:B10. > Using Excel 2003, > Thanks, > Amnon > > From: macropod on 25 Feb 2010 05:51 Hi Amnon, Simply apply the same formula to each of the cells. -- Cheers macropod [Microsoft MVP - Word] "Amnon Wilensky" wrote in message news:uGXipBbtKHA.928(a)TK2MSFTNGP04.phx.gbl...> Hi, > I am using the formula for reversing string I have got from the forum but it > works on a single cell. How can use it on a multiply cells. > For example: suppose I have a list of names in cells A1:A10 and I want to > reverse them to cells B1:B10. > Using Excel 2003, > Thanks, > Amnon > > > From: Amnon Wilensky on 25 Feb 2010 20:14 Thanks, Amnon "macropod" wrote in message news:O1kZ3hgtKHA.4752(a)TK2MSFTNGP04.phx.gbl...> Hi Amnon, > > Simply apply the same formula to each of the cells. > > -- > Cheers > macropod > [Microsoft MVP - Word] > > > "Amnon Wilensky" wrote in message > news:uGXipBbtKHA.928(a)TK2MSFTNGP04.phx.gbl... >> Hi, >> I am using the formula for reversing string I have got from the forum but >> it works on a single cell. How can use it on a multiply cells. >> For example: suppose I have a list of names in cells A1:A10 and I want >> to reverse them to cells B1:B10. >> Using Excel 2003, >> Thanks, >> Amnon  |  Pages: 1 Prev: how to calculate billable rate using base rate and percentageNext: Thank you