#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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" |
#3
|
|||
|
|||
Awesome. Thank you So Much
|
|
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 |