Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate
col1 col2 1 1,2,3,4 2 3 4 I have data in col1 and I want to transfer the data into col2 with this lay out : 1,2,3,4 I used this syntax: =CONCATENATE(A1,",",A2,",",A3,",",A4) Questions: Is there a better way to create a short program to do this? assuming my data is 1 to 500 Thanks -- tbobo ------------------------------------------------------------------------ tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530 View this thread: http://www.excelforum.com/showthread...hreadid=512511 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate
If you want my opinion, I would save the file as text. Then I would open it
in Word. Ctrl+H. In the Find what, type ^p In the Replace with, type a comma Replace all. But you should also know a "quickie" concatenation method is (no need for that long word nobody remembers how to spell): =A1&A2&A3&A4.... ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "tbobo" wrote in message ... col1 col2 1 1,2,3,4 2 3 4 I have data in col1 and I want to transfer the data into col2 with this lay out : 1,2,3,4 I used this syntax: =CONCATENATE(A1,",",A2,",",A3,",",A4) Questions: Is there a better way to create a short program to do this? assuming my data is 1 to 500 Thanks -- tbobo ------------------------------------------------------------------------ tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530 View this thread: http://www.excelforum.com/showthread...hreadid=512511 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate
I've also done this:
A1: 1 A2: 2 B2: =A1&","&A2 A3: 3 B3 = B2&","&A3 (copy this down) A4: 4 B4 = B3&","&A4 (and so on) "tbobo" wrote in message ... col1 col2 1 1,2,3,4 2 3 4 I have data in col1 and I want to transfer the data into col2 with this lay out : 1,2,3,4 I used this syntax: =CONCATENATE(A1,",",A2,",",A3,",",A4) Questions: Is there a better way to create a short program to do this? assuming my data is 1 to 500 Thanks -- tbobo ------------------------------------------------------------------------ tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530 View this thread: http://www.excelforum.com/showthread...hreadid=512511 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate
Troy! thanks! it works for me! -- tbobo ------------------------------------------------------------------------ tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530 View this thread: http://www.excelforum.com/showthread...hreadid=512511 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate
You're welcome! :)
So glad I could help. ************ Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "tbobo" wrote in message ... Troy! thanks! it works for me! -- tbobo ------------------------------------------------------------------------ tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530 View this thread: http://www.excelforum.com/showthread...hreadid=512511 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate | Excel Discussion (Misc queries) | |||
IF, IF, Concatenate? | Excel Worksheet Functions | |||
Using Concatenate inside a vlookup | Excel Worksheet Functions | |||
Concatenate in Pocket Excel | Excel Worksheet Functions | |||
Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) |