Posted to microsoft.public.excel.programming

Will[_7_]

external usenet poster

Posts: 11

concatenate values / convert to csv help

Hi all,

I have a table with only one column which is serial#.

Could you help me to create a macro that will
concatenate "prd-" text with serial# value and save the
results as csv file in designated location. I am just
learning VBA.
The range in serial# colum is not static, it could change
every week. So the range like a1:a100 can not be assigned.

Thanks a lot and hugs to all,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
concatenate values	Flint springs	Excel Worksheet Functions	4	May 23rd 09 08:41 PM
Concatenate Values with VBA	jlclyde	Excel Discussion (Misc queries)	2	October 1st 08 07:05 PM
Concatenate values IF()	Nikki	Excel Worksheet Functions	21	May 12th 07 11:06 PM
Concatenate values	dan	Excel Worksheet Functions	2	August 14th 06 11:03 PM
concatenate function/convert military to AM/PM	brianwakin	Excel Worksheet Functions	1	September 1st 05 07:40 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us