Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine text
Does anyone know a macro that would combine these cells into one?
Thanks in advance Actual Output 10001 Need Your Help 10002 Thank You in Advance Desired Output 10001 Need Your Help 10002 Thank You in Advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine text
Do you want a macro?
It can be done without a macro using the ampersand. =A1 & " " & B1 & " " & B2 & " " & B3 Gord Dibben MS Excel MVP On Tue, 1 May 2007 12:20:02 -0700, Lisa wrote: Does anyone know a macro that would combine these cells into one? Thanks in advance Actual Output 10001 Need Your Help 10002 Thank You in Advance Desired Output 10001 Need Your Help 10002 Thank You in Advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine text
It is a huge report and it would take a long time to combine all the cells.
The only problem is that the rows are not consistent. I tried to use the €śif€ť and then €śconcatenate€ť didnt work. The report looks like this. Row 10001 €“ Help Row 10002 Need Your Help Row 10003 Thanks "Gord Dibben" wrote: Do you want a macro? It can be done without a macro using the ampersand. =A1 & " " & B1 & " " & B2 & " " & B3 Gord Dibben MS Excel MVP On Tue, 1 May 2007 12:20:02 -0700, Lisa wrote: Does anyone know a macro that would combine these cells into one? Thanks in advance Actual Output 10001 Need Your Help 10002 Thank You in Advance Desired Output 10001 Need Your Help 10002 Thank You in Advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine text
Lisa
Copying the formulas would not take long, but if the data is inconsistent then that throws a wrinkle into it. I'll look at whipping up a macro but others here are pretty handy with the formulas so hang in. Someone can help. Gord On Tue, 1 May 2007 13:14:01 -0700, Lisa wrote: It is a huge report and it would take a long time to combine all the cells. The only problem is that the rows are not consistent. I tried to use the “if” and then “concatenate” didn’t work. The report looks like this. Row 10001 – Help Row 10002 Need Your Help Row 10003 Thanks "Gord Dibben" wrote: Do you want a macro? It can be done without a macro using the ampersand. =A1 & " " & B1 & " " & B2 & " " & B3 Gord Dibben MS Excel MVP On Tue, 1 May 2007 12:20:02 -0700, Lisa wrote: Does anyone know a macro that would combine these cells into one? Thanks in advance Actual Output 10001 Need Your Help 10002 Thank You in Advance Desired Output 10001 Need Your Help 10002 Thank You in Advance |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine text
Any help would be greatly appreciated.
"Gord Dibben" wrote: Lisa Copying the formulas would not take long, but if the data is inconsistent then that throws a wrinkle into it. I'll look at whipping up a macro but others here are pretty handy with the formulas so hang in. Someone can help. Gord On Tue, 1 May 2007 13:14:01 -0700, Lisa wrote: It is a huge report and it would take a long time to combine all the cells. The only problem is that the rows are not consistent. I tried to use the €śif€ť and then €śconcatenate€ť didnt work. The report looks like this. Row 10001 €“ Help Row 10002 Need Your Help Row 10003 Thanks "Gord Dibben" wrote: Do you want a macro? It can be done without a macro using the ampersand. =A1 & " " & B1 & " " & B2 & " " & B3 Gord Dibben MS Excel MVP On Tue, 1 May 2007 12:20:02 -0700, Lisa wrote: Does anyone know a macro that would combine these cells into one? Thanks in advance Actual Output 10001 Need Your Help 10002 Thank You in Advance Desired Output 10001 Need Your Help 10002 Thank You in Advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I combine text from several cells into one? | Excel Discussion (Misc queries) | |||
how to combine text into a cell??? | Excel Worksheet Functions | |||
text trim combine | Excel Discussion (Misc queries) | |||
Formula to combine text? | Excel Worksheet Functions | |||
Combine date with text | Excel Worksheet Functions |