| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reverse string on multiply cells
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reverse string on multiply cells
See this link...
http://chandoo.org/wp/2009/11/19/rev...list-in-excel/ -- Rick (MVP - Excel) "Amnon Wilensky" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reverse string on multiply cells
Hi Amnon,
Simply apply the same formula to each of the cells. -- Cheers macropod [Microsoft MVP - Word] "Amnon Wilensky" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reverse string on multiply cells
Thanks,
Amnon "macropod" wrote in message ... Hi Amnon, Simply apply the same formula to each of the cells. -- Cheers macropod [Microsoft MVP - Word] "Amnon Wilensky" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I multiply (1 cell) times a rge of cells to a rge of cells | Excel Worksheet Functions | |||
| sum cells with color and multiply | Excel Discussion (Misc queries) | |||
| Reverse and format string | Excel Discussion (Misc queries) | |||
| add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
| REVERSE SINGLE CELL TEXT STRING | Excel Worksheet Functions | |||
Linear Mode
