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: 1
Default Excell VBA Macro with Symbols

I need to take data out of column A and put that with all commas but i
need to add the following symbol ', example

11111
11112
11113
11114

I need to create a macro that takes this column and create it as follows
11111,11112,11113,11114

but i need the symbol added so that it looks as follows:
'11111','11112','11113','11114'

*** Sent via Developersdex http://www.developersdex.com ***
 
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
Symbols on the keyboard are not the symbols on the screen.... Lisha Excel Discussion (Misc queries) 2 May 22nd 10 07:29 AM
How to insert maths symbols into an excell function? Maths symbols on excell Excel Worksheet Functions 1 May 16th 10 08:53 PM
How do you insert wingdings symbols using VBA macro? mamabear Excel Programming 2 July 18th 07 07:38 AM
Inserting Symbols via a macro GRussell31 Excel Programming 9 March 4th 06 05:14 PM
converting Lotus 123 macro to Excell macro mark h Excel Discussion (Misc queries) 6 July 11th 05 01:28 PM


All times are GMT +1. The time now is 06:16 PM.

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"