Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I use replace(alt+H) for mutiple items needing replace
I want to replace some chars. with some values....
Fo example I want to replace a,b,c,d,e with 1,2,3,4,5 and I don't know how to do it!!! I am tired of using "alt+h" for each cell I need a replacement |
#2
|
|||
|
|||
Instead of selecting a single cell, select a range of cells and THEN select
Ctrl-H. HTH, -- Gary Brown If this post was helpful to you, please select 'YES' at the bottom of the post. "Gery" wrote: I want to replace some chars. with some values.... Fo example I want to replace a,b,c,d,e with 1,2,3,4,5 and I don't know how to do it!!! I am tired of using "alt+h" for each cell I need a replacement |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple items in database | Excel Worksheet Functions | |||
How to total items if they fall between a date range | Excel Discussion (Misc queries) | |||
Computing totals for tax and non-tax items | Excel Worksheet Functions | |||
Can you reformat order of items in Pivot Tables after refresh? | Excel Discussion (Misc queries) | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) |