I am trying to format hundreds of account numbers with beginning and ending apostrophes and each number ending with a comma.
I have the comma added as follows:=B2&","
I have the beginning apostrophe as follows: ="'"&C2
However I am not able to get the ending apostrophe or the two above to work properly.
Data set currently has accounts as follows 100-100-100, I am looking to have all the data as '100-100-100',
I need the data in this format for SQL import.