Home |
Search |
Today's Posts |
#1
|
|||
|
|||
mass cell data editing
Hello, I have many cells containing the same data. I would like to change a
letter or number in all of them at the same time instead of clicking on each cell and editing one cell at a time. Please see below for example: I have; A B C 1 AB1 AB1 AB1 2 AB1 AB1 AB1 3 AB1 AB1 AB1 I want to change all cell data of "AB1" to "AX1". I now have to click on each cell and manually edit. How can I select all cells above, ie., A1 thru C3 and change all "AB1" cell data to "AX1" all at the same time? Below is what I would like to end up with. A B C 1 AX1 AX1 AX1 2 AX1 AX1 AX1 3 AX1 AX1 AX1 I appreciate any advice anyone can give me! This would really help. Thank you in advance, George B. |
#2
|
|||
|
|||
Select the entire range. From the Edit menu select Replace. In Find What type
AB1. In Replace With type AX1. Click on Replace All. "George B." wrote: Hello, I have many cells containing the same data. I would like to change a letter or number in all of them at the same time instead of clicking on each cell and editing one cell at a time. Please see below for example: I have; A B C 1 AB1 AB1 AB1 2 AB1 AB1 AB1 3 AB1 AB1 AB1 I want to change all cell data of "AB1" to "AX1". I now have to click on each cell and manually edit. How can I select all cells above, ie., A1 thru C3 and change all "AB1" cell data to "AX1" all at the same time? Below is what I would like to end up with. A B C 1 AX1 AX1 AX1 2 AX1 AX1 AX1 3 AX1 AX1 AX1 I appreciate any advice anyone can give me! This would really help. Thank you in advance, George B. |
#3
|
|||
|
|||
Thank you so much Rowan! This will save me a whole lot of time :-)
I really appreciate it! George B. "Rowan" wrote: Select the entire range. From the Edit menu select Replace. In Find What type AB1. In Replace With type AX1. Click on Replace All. "George B." wrote: Hello, I have many cells containing the same data. I would like to change a letter or number in all of them at the same time instead of clicking on each cell and editing one cell at a time. Please see below for example: I have; A B C 1 AB1 AB1 AB1 2 AB1 AB1 AB1 3 AB1 AB1 AB1 I want to change all cell data of "AB1" to "AX1". I now have to click on each cell and manually edit. How can I select all cells above, ie., A1 thru C3 and change all "AB1" cell data to "AX1" all at the same time? Below is what I would like to end up with. A B C 1 AX1 AX1 AX1 2 AX1 AX1 AX1 3 AX1 AX1 AX1 I appreciate any advice anyone can give me! This would really help. Thank you in advance, George B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell formatting problems | New Users to Excel | |||
Input cell on Data Table will not work | Excel Discussion (Misc queries) | |||
Import Data into same cell | Excel Discussion (Misc queries) | |||
Repeat Cell Data | Excel Worksheet Functions | |||
sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions |