Previous Topic Next Topic

Format data in excel for Db transaction

Solved/Closed
ms.pre - Sep 10, 2008 at 08:29 AM
 holly - May 4, 2011 at 10:08 AM
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!
Related:

1 response

Answer 1 / 1
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 ?
4
Nigel
Nov 7, 2008 at 10:06 AM
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
holly
May 4, 2011 at 10:08 AM
Thank you Nigel for this it is helpful
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses