Can I copy only certain data from a cell?

I

Ian1976

Board Regular
Joined
Feb 4, 2016
Messages
139
Office Version
  1. 365
Platform
  1. Windows
Hi
I have sheet1 with the date and time in this format in cell A1, like this....

06/08/2019 20:20:00

Is it possible to vlookup this cell to place only the time on to sheet2 in cell A1?

Thanks
Ian
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Sort by date Sort by votes
Does this do what you want?
Note this assumes the date is always 10 characters. The result is text not excel time.

=RIGHT(Sheet1!A1,LEN(Sheet1!A1)-11)
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question Question
conditional formatting based on multiple criteria
2
Replies
13
Views
406
dreid1011
dreid1011
Keebler
  • Solved
excel function from another cell
Replies
6
Views
157
smozgur
smozgur
K
  • Solved
Two dates, two cells - How do I format the second cell to change colour after x amount of time has elapsed from the first date?
Replies
8
Views
120
Kikaiki
K
S
  • Solved
Hyperlink point to specific cell in another sheet
Replies
2
Views
189
Schturman
S
D
  • Solved
Using VLOOKUp to find a Date in a Data Worksheet
2
Replies
13
Views
257
Alex Blakenburg
A

Forum statistics

Threads
1,224,817
Messages
6,181,144
Members
453,021
Latest member
Justyna P

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
Back
Top