Format data in excel for Db transaction

ms.pre - Sep 10, 2008 at 08:29 AM
 holly - May 4, 2011 at 10:08 AM

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

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


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

Thank you Nigel for this it is helpful