Pick up text/value

Jonathan Lee

New Member
Joined
Feb 22, 2015
Messages
33
Office Version
  1. 2016
Platform
  1. Windows
Hi Shifus,

Need you help here.

I have a range of cells in columns. Unfortunately each row the values were placed in different columns. How can I put all into one column?

Example below, texts are in A, B and C. I need to put all into D.

Thanks.

ABCD
1appleapple
2orangeorange
3grapesgrapes
 
Further formula options.

If the columns with the text values do not contain formulas, then you could use a formula like I have in col U.
If they do contain formulas and you would prefer to avoid the Ctrl+Shift+Enter formula confirmation, you could use a formula like I have in col V

21 09 15.xlsm
ABCDTUV
1appleappleapple
2orangeorangeorange
3grapesgrapesgrapes
Text Value
Cell Formulas
RangeFormula
U1:U3U1=LOOKUP("ZZZ",A1:T1)
V1:V3V1=INDEX(A1:T1,MATCH(TRUE,INDEX(A1:T1<>"",0),0))
 
Upvote 0
Solution

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Further formula options.

If the columns with the text values do not contain formulas, then you could use a formula like I have in col U.
If they do contain formulas and you would prefer to avoid the Ctrl+Shift+Enter formula confirmation, you could use a formula like I have in col V

21 09 15.xlsm
ABCDTUV
1appleappleapple
2orangeorangeorange
3grapesgrapesgrapes
Text Value
Cell Formulas
RangeFormula
U1:U3U1=LOOKUP("ZZZ",A1:T1)
V1:V3V1=INDEX(A1:T1,MATCH(TRUE,INDEX(A1:T1<>"",0),0))
Thanks. Exactly what I needed.
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,020
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top