Format data in excel for Db transaction

Solved/Closed
Report
-
 holly -
Hello,

I have a simple question, I have a range of cells with numbers in each cell. I want to add a single quote or apostrophe in the start and end of each number. That way I can transfer this list into Oracle as strings easily. This could be done using a macro however I am not sure how to format and edit the contents for each cell. Data = 123 should get replaced by '123'.

Thanks for your help!

1 reply

Posts
16
Registration date
Saturday August 30, 2008
Status
Member
Last seen
March 31, 2009
4
can you tell me in oracle what are you planning to do ?
4
If your data (123) is in cell E21, add the following formula to the cell which should contain '123':

=CONCATENATE("'",E21,"'")

i.e. =CONCATENATE(double-quote, single-quote, double-quote,comma,E21,comma,double-quote, single-quote, double-quote)

Nigel
0
Thank you Nigel for this it is helpful
0