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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

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
Thank you Nigel for this it is helpful