Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Seperate two pieces of data in one cell

Status
Not open for further replies.
skygirl65

skygirl65

Technical User
Jul 18, 2004
32
US
I have a cell with date and time in it. How can I seperate that data into two cells?
 
Sort by date Sort by votes
If only thing which separates them is a space: Select Column, go to Data, click Text To Columns. Use space as separator.
 
Upvote 0 Downvote


Sky,

Why do Dates and Times seem to be so much trouble? faq68-5827

Why do you want the data in 2 cells? Visual? Calculation? Reference?

Skip,
[sub]
[glasses] [red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
165
Andrzejek
Andrzejek
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
182
ladyck3
ladyck3
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
236
combo
combo
Cpreston
  • Locked
  • Question
If cell is blank use data from another cell 1
Replies
10
Views
177
Andrzejek
Andrzejek
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
480
combo
combo

Part and Inventory Search

Sponsor

Back
Top