Microsoft Office Forums A formula to Take what I need from a cell and add the rest

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-20-2013, 07:07 AM
bremen22 bremen22 is offline A formula to Take what I need from a cell and add the rest Windows 7 64bit A formula to Take what I need from a cell and add the rest Office 2007
Advanced Beginner
A formula to Take what I need from a cell and add the rest
 
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Question A formula to Take what I need from a cell and add the rest

Good Morning,

I am working with a rather large data set and I need to take extract a portion of a cell and add something else to it.

In the "G" column of my data I have a number that looks like this

261209-002 From this number I need to extract the first 3 characters. in this case "261". I then need to add a zero (always a zero) and a hyphen in the middle. so from the above example It will read 26-10 when I'm finished.
Reply With Quote
  #2  
Old 11-20-2013, 10:16 AM
BobBridges's Avatar
BobBridges BobBridges is offline A formula to Take what I need from a cell and add the rest Windows 7 64bit A formula to Take what I need from a cell and add the rest Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 614
BobBridges will become famous soon enoughBobBridges will become famous soon enough
Default

I take it this value "261209-002" is text, not numeric, bremen22. If so, and supposing it's in G1, then I would use this formula:
Code:
=LEFT(G1,2)&"-"&MID(G1,3,1)&"0"
Reply With Quote
  #3  
Old 11-21-2013, 08:05 AM
bremen22 bremen22 is offline A formula to Take what I need from a cell and add the rest Windows 7 64bit A formula to Take what I need from a cell and add the rest Office 2007
Advanced Beginner
A formula to Take what I need from a cell and add the rest
 
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Default

Awesome. Thank you So Much
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
A formula to Take what I need from a cell and add the rest formula help with total in same cell jterr Excel 14 02-25-2013 05:43 PM
Change formula cell range based on cell value Scoth Excel 4 10-25-2012 07:51 AM
A formula to Take what I need from a cell and add the rest Keep cell in formula constant jprt68 Excel 1 06-26-2012 08:31 AM
A formula to Take what I need from a cell and add the rest Formula in a Cell with condition? Learner7 Excel 1 07-19-2010 10:10 AM
A formula to Take what I need from a cell and add the rest Protect formula in cell? markg2 Excel 4 05-24-2010 11:50 AM


All times are GMT -7. The time now is 09:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft