# If function with unique function

#### RAJESH1960

##### Active Member
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...
Book1
ABCDEFGH
1Cash & CarryCash & CarryCash &amp; Carry
2Sunday & MondaySunday & MondaySunday &amp; Monday
3January & FebruaryJanuary & FebruaryJanuary &amp; February
4ABC & Co.ABC & Co.ABC &amp; Co.
5=IF(A2="","",A2)
6Hello Guys,
7In C column I want &amp; in place of & in all rows as shown in column F
8I don’t want to use the find replace function as the column C will be in another sheet and will be protected
9Is this possible….?
10
11
12
13
Sheet1
Cell Formulas
RangeFormula
C1:C4C1=IF(A1="","",A1)

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

#### Fluff

##### MrExcel MVP, Moderator
Excel Formula:
``=SUBSTITUTE(A1,"&","&amp;")``

#### RAJESH1960

##### Active Member
Excel Formula:
``=SUBSTITUTE(A1,"&","&amp;")``
=IF(A1="","",SUBSTITUTE(A1,"&","&amp;"))
Got it. Thanks Fluff
I'm not seeing where 'unique' comes into the question,
Cell Formulas
RangeFormula
C1:C4C1=IF(A1="","",A1)
F1:F4F1=SUBSTITUTE(C1,"&","&amp;")

Also, it would be preferable if you type your question into your post, not your example sheet.
As I am learning and trying new things, I find everything unique. Thanks Jasonb

#### Fluff

##### MrExcel MVP, Moderator

You don't need the If statement. If A1 is blank the substitute function will return nothing.

#### RAJESH1960

##### Active Member
You don't need the If statement. If A1 is blank the substitute function will return nothing.
Wow! Good to know... I have used the if function in more than 20 columns. This is getting more interesting and easier. Thanks for the update

My pleasure.

Replies
2
Views
233
Replies
6
Views
122
Replies
3
Views
173
Replies
12
Views
333
Replies
2
Views
86

1,126,888
Messages
5,621,426
Members
415,839
Latest member
Pollydooner

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back