Move multiple values within a single cell into a column and bring the data

A

AndreMerrill

New Member
Joined
Nov 23, 2012
Messages
3
A single cell has the following values:

L40041 L40061 L40231 L40311 L40381 L40382

I need each value in one column and link the data from the row. I used Text to Column to separate the values, but now I need them moved into a column and bring in the corresponding data.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
You must log in or register to reply here.

Similar threads

M
  • Question
Copying values using an IF nested inside For Each
Replies
1
Views
236
OaklandJim
O
R
  • Question
Move Rows from multiple sheets in workbook to single sheet based on cell value
Replies
1
Views
374
Jamie McMillan
J
B
  • Question
Creating link between different columns
2
Replies
11
Views
311
SQUIDD
S
N
  • Solved
Excel Formula to Count a Specific Value in a Range with Cells Containing Multiple Values
2
Replies
13
Views
929
steve the fish
steve the fish
N
  • Question
Return Count of a String Value in a Range Based on Month
Replies
2
Views
250
NorthbyNorthwest
N

Forum statistics

Threads
1,195,601
Messages
6,010,653
Members
441,558
Latest member
lambierules

Share this page

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
Top