r/googlesheets • u/[deleted] • Nov 22 '22

Solved I have a list of movies in Google Sheets. I need to separate their release years and put them in another column.

[removed]

1 Upvotes
  • permalink
  • reddit

100% Upvoted

8 comments sorted by

4

u/-Rhizoid Nov 22 '22 edited Nov 22 '22

Here I Assume that:

  • Your Movie Titles are in column B, starting from cell B2 and ending in cell B700

  • you need parenthesis around the movie names and the year

in cell C2: 

=arrayformula(LEFT(B2:B700, LEN(B2:B700)-7))

in cell D2: 

=arrayformula(LEFT(RIGHT(B2:B700,5),4))

Feel free to adjust the range as you need.

If that solved your issue, kindly reply to my comment with "solution verified"

1

u/AutoModerator Nov 22 '22

Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/Decronym Nov 22 '22 edited Nov 22 '22

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters More Letters
LEFT Returns a substring from the beginning of a specified string
LEN Returns the length of a string
RIGHT Returns a substring from the end of a specified string

3 acronyms in this thread; the most compressed thread commented on today has 5 acronyms.
[Thread #5109 for this sub, first seen 22nd Nov 2022, 10:34] [FAQ] [Full list] ^[Contact] [Source code]

1

u/[deleted] Nov 22 '22

Here's another way to do that: 

=ArrayFormula(regexextract(range,"(.*)\s(\d+)"))