Hey guys,
I'm new to the forum and I'm running in to a small issue where I have to go thru a thousand odd cells of data in a column and change another cell in the same row with text. For example:
2 A
3 B
4 C
10 D
6 E
4 F
6 G
10 H
10 I
7 J
7 K
10 L
8 M
6 N
4 O
9 P
3 Q
2 R
9 S
4 T
6 U
2 V
2 W
9 X
7 Y
6 Z
I have to go thru the first column and search for "10" and then replace it's neighboring cell with the word "TEN". Is there a way to automate this process?
I'm new to the forum and I'm running in to a small issue where I have to go thru a thousand odd cells of data in a column and change another cell in the same row with text. For example:
2 A
3 B
4 C
10 D
6 E
4 F
6 G
10 H
10 I
7 J
7 K
10 L
8 M
6 N
4 O
9 P
3 Q
2 R
9 S
4 T
6 U
2 V
2 W
9 X
7 Y
6 Z
I have to go thru the first column and search for "10" and then replace it's neighboring cell with the word "TEN". Is there a way to automate this process?