Excel formatting...

Question

I have a spreadsheet with text in column A. For example

A1=MY TEXT1
A2=MY TEXT2
A3=MY TEXT3
A4=MY TEXT4
A5=MY TEXT5

I want to add an apostrophe to the front and back of the text Result to be:

B1='MY TEXT1'
B2='MY TEXT2'
B3='MY TEXT3'
B4='MY TEXT4'
B5='MY TEXT5'

It seems like a straight forward thing to do. Any one know how?

Answer 1

=CONCATENATE("'";A1;"'")

Answer 2

Use this formula:

="'" & A1 & "'"