Excel formatting

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'
开发者_如何学JAVA

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

Use this formula:

="'" & A1 & "'"

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