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 Combining cell values in a list


Hey all,

How can I write a sub to combine the values of two different cells?

eg cell A1 = '04' and cell B2 = 'BOB BROWN'

desired output being a cell '04 BOB BROWN'

This is to be used for a list of values the length of which will
change each time i refreash it.

Many Thanks,

Hayley


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=498759

 
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
combining two cell values to one value to chart SteveZmyname Charts and Charting in Excel 4 October 28th 09 03:28 PM
If a cell matches a list of values...... Simon Excel Discussion (Misc queries) 3 August 14th 09 09:01 PM
Combining Formula and Data Validation List in a Single Cell Benny Excel Worksheet Functions 0 May 13th 08 09:48 PM
Creating a list of cell values Link New Users to Excel 3 February 14th 08 09:32 AM
Want to be able to click on a cell and have a list box appear to give values to populate a cell Richard Zellmer Excel Programming 2 September 16th 03 11:12 PM


All times are GMT +1. The time now is 08:34 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"