?
Solved

Excel 2010 remove 2 middle characters

Posted on 2011-04-26
3
Medium Priority
?
696 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:jetli87
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
Draxonic earned 2000 total points
ID: 35472621
=REPLACE(A1,4,2,"")
0
 
LVL 1

Author Comment

by:jetli87
ID: 35472626
perfect thanks.
0
 
LVL 6

Expert Comment

by:Draxonic
ID: 35472628
Function Syntax:

REPLACE(old_text, start_num, num_chars, new_text)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question