Splitting a cell
Can you create a formula to spit a cells contents.
EX. in A1 = W3056 I would like A3= 30 and A4 = 56 Is this possible |
Splitting a cell
Depending on what your criteria is you can use text functions (LEFT, MID, or
RIGHT), and then copy and paste special selecting values to remove the formulas. For example: A3: =MID(A1,2,2) A5: =RIGHT(A1,2) "David" wrote: Can you create a formula to spit a cells contents. EX. in A1 = W3056 I would like A3= 30 and A4 = 56 Is this possible |
Splitting a cell
In A3 put....
=MID(A1,2,2) In A4 put.... =RIGHT(A1,2) Vaya con Dios, Chuck, CABGx3 "David" wrote: Can you create a formula to spit a cells contents. EX. in A1 = W3056 I would like A3= 30 and A4 = 56 Is this possible |
All times are GMT +1. The time now is 04:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com