Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I know there's an easy way to do this, but can't remember...
I want to copy data ie Mr John Bloggs into an excel sheet. However, I want each name to be in a different cell, ie Mr in A1, John in B1 and Bloggs in C1 How do I do this? |
#2
![]() |
|||
|
|||
![]()
After the string is copied over to Excel, highlight the cell, or the entire
column of like cells and do Data Text to columns Delimited and use space as the delimiter......... Vaya con Dios, Chuck, CABGx3 "ASBiss" wrote in message ... I know there's an easy way to do this, but can't remember... I want to copy data ie Mr John Bloggs into an excel sheet. However, I want each name to be in a different cell, ie Mr in A1, John in B1 and Bloggs in C1 How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
exporting single cells to Word | Excel Discussion (Misc queries) | |||
Excel should allow multiple hyperlinks in a single cell | Excel Discussion (Misc queries) | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
How do I email selected excel cells to multiple recipients? | Excel Worksheet Functions |