Prev: how to calculate billable rate using base rate and percentage
Next: Thank you
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" <wilensky(a)isdn.net.il> 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" <wilensky(a)isdn.net.il> 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" <macropod(a)invalid.invalid> 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" <wilensky(a)isdn.net.il> 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 percentage
Next: Thank you