If function with unique function

[RAJESH1960]

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
	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)

 

[Fluff]

How about

=SUBSTITUTE(A1,"&","&")

 

[jasonb75]

I'm not seeing where 'unique' comes into the question,

Book1
	A	B	C	D	E	F
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.
Sheet1

Cell Formulas
Range	Formula
C1:C4	C1	=IF(A1="","",A1)
F1:F4	F1	=SUBSTITUTE(C1,"&","&")

Also, it would be preferable if you type your question into your post, not your example sheet.

 

[RAJESH1960]

How about

=SUBSTITUTE(A1,"&","&")

=IF(A1="","",SUBSTITUTE(A1,"&","&"))
Got it. Thanks Fluff?

I'm not seeing where 'unique' comes into the question,

Book1
	A	B	C	D	E	F
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.
Sheet1

Cell Formulas
Range	Formula
C1:C4	C1	=IF(A1="","",A1)
F1:F4	F1	=SUBSTITUTE(C1,"&","&")

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]

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

 

[RAJESH1960]

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

 

[Fluff]

My pleasure.