Thread
:
A formula to Take what I need from a cell and add the rest
View Single Post
11-20-2013, 10:16 AM
BobBridges
Windows 7 64bit
Office 2010 32bit
Expert
Join Date: May 2013
Location: USA
Posts: 700
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"
BobBridges
View Public Profile
Find all posts by BobBridges