RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello guys,
I have a unique question. Hope you understand it and will help me to know how and whether this is possible at all...
I have a unique question. Hope you understand it and will help me to know how and whether this is possible at all...
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Cash & Carry | Cash & Carry | Cash & Carry | |||||||
2 | Sunday & Monday | Sunday & Monday | Sunday & Monday | |||||||
3 | January & February | January & February | January & February | |||||||
4 | ABC & Co. | ABC & Co. | ABC & Co. | |||||||
5 | =IF(A2="","",A2) | |||||||||
6 | Hello Guys, | |||||||||
7 | In C column I want & in place of & in all rows as shown in column F | |||||||||
8 | I don’t want to use the find replace function as the column C will be in another sheet and will be protected | |||||||||
9 | Is this possible….? | |||||||||
10 | ||||||||||
11 | ||||||||||
12 | ||||||||||
13 | ||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C1:C4 | C1 | =IF(A1="","",A1) |