LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
KK KK is offline
external usenet poster
 
Posts: 61
Default how to make macro to combine text from 2 cells?

I tried recording macro and it does not work with relative addressing.

A1 abc A2 xyz

I want A3 to be abcxyz

If you run above recorded macro for cells B1 B2 and B3 I get copy of A1 A2 A3
not the real content of B1 and B2

Thanks for your help!
 
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
Combine Text Cells lightbulb Excel Discussion (Misc queries) 3 July 24th 08 02:40 PM
Combine text and cells Jen Excel Discussion (Misc queries) 2 May 21st 07 08:48 PM
How can I combine text from several cells into one? Michael Excel Discussion (Misc queries) 5 January 16th 07 10:25 PM
Macro to Combine 2 columns to make one column without merging JRM Excel Discussion (Misc queries) 1 December 31st 05 08:27 PM
combine worksheet functions to make macro to automate everything mike Excel Programming 4 December 21st 05 05:13 PM


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