Format data in excel for Db transaction
Solved/Closed
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!
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!
Related:
- Format data in excel for Db transaction
- Marksheet format in excel - Guide
- How to change date format in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Steam transaction history - Guide
- Transfer data from one excel worksheet to another automatically - Guide
1 response
dhlexp
Posts
16
Registration date
Saturday August 30, 2008
Status
Member
Last seen
March 31, 2009
4
Sep 10, 2008 at 03:23 PM
Sep 10, 2008 at 03:23 PM
can you tell me in oracle what are you planning to do ?
Nov 7, 2008 at 10:06 AM
=CONCATENATE("'",E21,"'")
i.e. =CONCATENATE(double-quote, single-quote, double-quote,comma,E21,comma,double-quote, single-quote, double-quote)
Nigel
May 4, 2011 at 10:08 AM