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

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

11-20-2013, 10:16 AM

BobBridges BobBridges is offline

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: 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"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
Keep cell in formula constant	jprt68	Excel	1	06-26-2012 08:31 AM
Formula in a Cell with condition?	Learner7	Excel	1	07-19-2010 10:10 AM
Protect formula in cell?	markg2	Excel	4	05-24-2010 11:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:38 AM.