Excel Formula issue

Question

Hi ,

i am using excel and downloaded data but need to seperate the year into a new column

FIR-2024-11-04-GJ-01:43:51 so this must return 2024

Answer 1

Hi,

Replace the comma with a semi-colon.

Answer 2

Hi, Thanks but mines give me this error ,please assist

Answer 3

Hi,

In cell B2, enter this formula

=CHOOSECOLS(TEXTSPLIT(A2,"-"),2)

Hope this helps.

Answer 4

Dear respected M1DL,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description,

=MID(A1, FIND("-", A1) + 1, 4)

If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

Answer 5

With such a text in A2:

=INDEX(TEXTSPLIT(A2, "-"), 2)

will return 2024 as a text value. If you prefer it as a number value:

=--INDEX(TEXTSPLIT(A2, "-"), 2)