Search : in
By :

Format data in excel for Db transaction

Last answer on Feb 21, 2009 11:16:35 pm GMT ms.pre, on Sep 10, 2008 1:29:53 pm BST 
 Report this message to moderators

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!

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Format data in excel for Db transaction » in :
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Download Excel Viewer Show
Download Format Factory ShowFormat Factory is an application that allows conversion of various types of media files. It has various characteristics that allow you to customize a lot of stuff like: Convert video formats, audio and picture shows. Repair damaged files. Reduce...
Download Invoice Generator Show
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
HTML forms ShowForms Interactive forms let web page authors give their pages interactive elements, such as for receiving messages from their readers, much like the reply cards found in some magazines. The reader enters information by filling in fields or clicking...
Ask your question Reply

1

dhlexp, on Sep 10, 2008 8:23:58 pm BST

Can you tell me in oracle what are you planning to do ?

   
Reply to dhlexp

2

Nigel, on Nov 7, 2008 3:06:12 pm GMT
  • +2

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

   
Reply to Nigel

3

 the name Nigel is dumb, on Feb 21, 2009 11:16:35 pm GMT

You have a stupid name Nigel

   
Reply to the name Nigel is dumb
Ask your question Reply
They need your help