Excel 2010 remove 2 middle characters

Hi Gurus,

I have a cell that contains the below data, I need to remove the 4th and 5th numbers from the middle.

Original:   01-1001
Ideal:       01-01

I have 500 cells that I need to fix.
LVL 1
jetli87Asked:
Who is Participating?
 
DraxonicConnect With a Mentor Commented:
=REPLACE(A1,4,2,"")
0
 
jetli87Author Commented:
perfect thanks.
0
 
DraxonicCommented:
Function Syntax:

REPLACE(old_text, start_num, num_chars, new_text)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.