LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default adding a single quote and comma to every cell in Excel

I need to make a script where I can add a single quote to the number in each
cell in Excel and after the second quote a comma. Hence the cell would start
like

08558952

and afterwards would look like,

'08558952',

I can't quite seem to get it done, any ideas?

TIA,

Rod
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
show apostrophe / single quote in cell Beans Excel Discussion (Misc queries) 3 April 4th 23 10:23 AM
CANNOT Import comma delimted, quote qualifed text file into Excel. Feiming Chen Excel Discussion (Misc queries) 2 August 28th 09 11:41 PM
Single Quote use in cell reference Eric Excel Worksheet Functions 1 May 7th 08 05:19 PM
How do I display a single quote in a cell? Brotha B Excel Discussion (Misc queries) 1 August 17th 07 02:09 AM
Single quote in a textbox disappear when put in cell? NooK[_19_] Excel Programming 2 June 30th 04 08:58 AM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"