separate into individual cells

joeloveszoe

Board Regular
Joined
Apr 24, 2014
Messages
55
hi
i copied a series of info from a pdf and when pasting into excel it all pastes in one cell - like this:
51626A 51629A 51633M 51640A 51640A 51645A 51649A B3B30FN B3B32FN B3B33FN C1823D C2P04AN C2P05AN C2P06AN C2P07AN C2P19AN C2P20AN C2P21AN C2P22AN
i want each to separate each item number into its own cell
there are spaces between the item number
how do i separate or re-paste so that each item number will go into its own cell?
i want the item number to be like this:

51626A
51629A
51633M
51640A
51640A

thanks in advance for taking the time to read my post and help me =)
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

jeffreybrown

Well-known Member
Joined
Jul 28, 2004
Messages
5,145
First use Text to Columns

Text to Columns
  • Highlight range to convert
  • Data >> Data Tools >> Text to Columns >> Check Delimited >> Next
  • Check Space >> Next >> Finish

Now highlight the range which was just created, copy, paste as values and transpose
 
Last edited:

joeloveszoe

Board Regular
Joined
Apr 24, 2014
Messages
55
hey jeff - thats perfection!!!! thanks sooo much!!!
really appreciate your help and step by step guidance!
=) have a happy day!
 

Watch MrExcel Video

Forum statistics

Threads
1,123,385
Messages
5,601,331
Members
414,446
Latest member
CRAVIN

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