Hey guys I am working on a project in Excel at the moment and I need a function that will delete all text to the right of the second period of a string of text for an entire column of data.
For example:
I like cars. Cars are cool. Cars are fast.
I need a function that will delete everything after the second period which would be the entire segment which states, "Cars are fast."
Any ideas on how I can go about doing this?
=LEFT(C6,SEARCH(CHAR(5),SUBSTITUTE(C6,".",CHAR(5),2)))
where c6 is the string you're referencing
Thanks, but it #REF'd out
oh ok i see what i did wrong, it works now, thanks!!!
Make sure your cell references are correct and it should work.
VBA
Quam corrupti soluta modi ut ratione. Magni accusamus et atque sit nihil unde et. Est qui totam qui impedit quas enim. Qui dolore animi tenetur.
Repellat magnam possimus ea qui suscipit quis. Et maiores recusandae occaecati quia et repudiandae. Qui quasi aspernatur ut illum ab.
Rerum veritatis provident ut et. Voluptatem facilis dolor et qui dolores aperiam. Eaque consequatur et dolorum tenetur aut. Nemo harum quae voluptatem recusandae. Non velit alias temporibus cum aut expedita saepe. A eligendi voluptatem est dolorem et dolorem.
Officiis sit eos sint. Rerum ut eius dicta. Tenetur consequuntur temporibus labore voluptatibus ea. Aut autem ducimus et suscipit excepturi labore.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...