Thread: Newb needs help.(adding text to multi-cells if...?)

I have a spread sheet with lets say 4 colums(a,b,c,d). What i want to do is add a '&' in front of anything in cell D?(If there is anything in that colum)

Example:

D1 BLANK
D2 BLANK
D3 has the word The
D4 Has the word fish
D5 BLANK
D6 Has the word Dog

So what I want to do is add the & symbol in front of anything in cell D that has text in it?

D1 Would stay BLANK
D2 Would stay:BLANK
D3 Would now be: & The
D4 Would now be: & fish
D5 Would stay:BLANK
D6 Would now be: & Dog

Hope my explanation makes sense?

Thank you and I look forward to any replies

-Jay

Use a helper column in E

In E1

=IF(D1<>"",CONCATENATE("&",D1),"")

and paste down Column E
So results will be in Column E

I guess you could copy and Paste Special (Values) to column D