I word kan du använda mönstermatchning. Men det saknas i excel (om du inte vill göra en UDF med hjälp av VBA - hmm det där blev fikonspråk).
Om du inte vill/kan plocka över tabelln till word så får du testa några andra metoder där du rensar data till en annan kolumn
1). Snabbfyllning Gör några exempel på önskat resultat i minst en angänsande cell (till höger). Markera kolumnen du vill ha resultaten i
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAO4AAABpCAYAAAA9Wx9CAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAtmSURBVHhe7Z1faBRJHse/OdAXQXDFBzd4kTPjQwjicWTRGRDv6UyERdkQDjzJgzg5WM7McueyHPEeNCzHurBJjgMz4sOyJ0hwL8tBZjx8OAnMGEaW8yHkIROXxDAKil4QRFAwV9VdPdMTp2eqOzPT0/b3A026ujr9J/P79q+qpuubtrW1tXVUYWVlBQcOHFAlQkgr8DP105G2tjasr1fVNiGkydQU7pYtW/Dq1StVIoS0AjWFu23bNjx58kSVCCGtQE3hbt++HW/fvsXy8rKRedlsJsR/ag5OWbx48QIvX77EmzdvKF5CfEZbuISQ1qFmU5kQ0npQuIQEEAqXkABC4RISQChcQgIIhUtIAGnK10Hye1/5zjMhG5GxId8RCCtCf+jo6FAlfZqScfnCBnEi7LEh30r0QlOE6/XiyPtP2GOjpYXLjEucYMZtIeG+fv1arZkw4xInmHFbRLhStHIygh1m3BK5iX70T+RUifgTG/fx14mzOFpcLuLGc1XVZFpCuJVEK2HGVRSmMfXwCI48nAOla+JfbOzB7393FXfOieV4O66k01hVNc3Ed+E6iVbCjGtSyGWA2Cf4JPYQU9MFtTXctERs7PgQ+9Vqs/FVuNVEK2HGlRRg6PajdrR/FAMyObGFtEJsrD64B+w/KHJw8/FNuLVEK2HGFRRyyCAGoVsI5Yq1DHJUro+xsYor/zD7uKcXe3ChZ7fa3lx8Ea6OaCUUrtVM/ghSt0K5MJMuletfbNj6uIce4fTENWRVTTNpunB1RSthUzmH768vY/n6MPr7+41l2Ch/H/pBqpaIjX2/wjHRcXnow8hyU4XrRrSS0Gfc3Bxm957C+M2buFlcxnFq7yzmQq7cloiNBz/ilmgF/fwDVW4iTROuW9FKwp5xc3Oz2FtsJlvI5vJezIZcuf7FRqmPe3SmIJrNZxBVNc3E6/27mh3kRrQ7duxQa8DTp0+xa9cuVSKkhIyNrVu3qlL4mJ+fRywWUyV9tDOul0xrEfaMS5wJe2x4vX9t4cqnosyiuosdjioTJ8IeGw0X7mZgxiVOMON6u/+mOGAUCgW0t5cPzRDyy0sDao3898KUWtOjTXSO16Xq5SKbLbrruvv+MXPFONFXh84aPwmx+HzuqlojbvXRtrKy0tCMK4fbJT99/W/jJyEWv/jTb4yfYY4Nr3+DpvRxCSH1hcIlJIBQuIQEEAqXkABC4UrSQ2iLjWNJFQNBEK+Z1A2XwjVNtuL3Hquyd5bGY8Z/N4iN20NvCeOxNmN7cRlKqzpCWpdmx7O2cFfvXcTRiR+x9/BmDT7SGBI3MIgRjDlMx4in1o3vgI1lsldtJaQV8SeetYW7p+cvuHPuDNzPY9hILybFDWSGI6rskaVxxGxPstKDzHzKDaXNP6hZH0P5g9D+u6JuUW0vsvFJOSQ+Hgt5XPE746KpaquznrjFY1Zqwwbkmp3vpdo5NO7hvaRO8eySluzjJvtqffAiOAaBb9VTLC8edcnR8v5esm8UXXmzPhXPInHZCjERYIMJYCyvnoIjWEgkVZ1JeiiCRHdK1cvjz6OvrD8pjicOkTLqJ9ErRDWY6FZluWQw3Kl2LRKQa3a8FynMCucoE2+1ewgvtePZPS0m3E4MZ6yAkYEBJCLlgWEinnKZYbG3SefxAUSzC8irsiSeKomn90QcmF80g3hpBlPZOEaKyhLHSol6CxG4o8koxs6XmjSdwyOIZ6cwY/ujx1Mi+NW6SRI/VI3RIF1zhe3qGlK2pp5xDsxjsewcDvcQSnTj2T0tmXEtzMCoHFxlzblIQt/oK7+gsa/IFBHrKSmXPnEVVegcRkZ8KvPqyVo+QFEiENfstL3iNUTQFc1iwf70IY5Ui2e3tLRwsbQonudRdG3sPqSHELE350SgaduORLo09hWZxTp2cSllkorIgDf2S6E7EbH1XxVBuuZK2yteQx4L2QqfD6mMUzx7oKWEmx4q7wOkL4usFB3A8WrBJzD2U+s16dyPbvHUG7VOJJqZsT5bbuo8joGord41Mgup1SoE45pt29U5+mxPpKXxUSQ1Pp+w4jWedfBBuNaoYwQJEblZ8US3mmS9J7rLmnt982PI2/qFRXonkYqLIFL7jXaNiXyji+gfimwnTmSeJ7KAkbLsJ/sleQxMqXprqfayg3wZorivOYDzzqh/UK7Z8V7kOVKIJ/uK9ZGpgcqfT6ioQzx7gNP6iG9wWh+n9RESKihcQgIIhUtIAGma59R//lD1W0USQn79N3N4TvbvpqenjfUwcfLkyWIf160+ODhFfMM+MHP37l1jPUwcPnyYg1OEhAkKl5AAQuESEkAoXEICCIVLSADRFq5pXaP+EfDENf0X5CtQ7rBgd4IghOigKdz7uP7sY9w5d9VYvjtcwJ9v3Vd1LpEOC/Ll9HVz6pnhBNFXn8nFhIQFTeEexBfHDqp1YM++Hux/9hirquwKOddzoxPEBheFEs4eR+khUS5L1ea+xYnfcuqbVlZvzDno50Qaibc+7v8eYXHnbmzW79HAcFboxv4Kc52q+SgZtijJH0rBbVirRDFgTHas7e9k0ZBzyFYF/ZxIA3Ev3OdpxGeAL20Z2DsiYEeTiI6d3+CFJBBBXtVHqfdEmQ3I0syUbZJybX8ng4aew8mipMJ2+jkRl7gSrjFAJYLuwrkzFWxM3GNkO4zhW0d/lWo+Sr0wE6JUwRJmprKIj5SEpO/v1IBzOPk2OW2nnxNxibZwpWgv4SzunOqtSxNZ9h9rOwJU91HqPT+GqGzKqox1wkpYrvydGnQO+jmRBqInXNE8vvTsYyR7dqsNm8EcaKkpWh0fJWufQdGEjZ94t7mtcPR3asY56OdEGoCecOVg1OLfbd/jyuUibjxX9W5IXza8eZBNIGI1M+VSNnor0fFR6sTxgSiyWdGELaZCgba/U4POQT8n0mA4rY/4Bqf1cVofIaGCwiUkgFC4hAQQek4R36DnFD2nSADh4BQHpwgJFRQuIQGEwiUkgFC4hAQQCpeQAKIt3Owt23vK19Pe3C9sWFPiilPbNmC4T1SpJyTMaAr3MR7u/LToOfXlzn/itFfPKekcIQQ5iBGMOc21Sw+hbz6OuFM9ISFHU7i78duekuNFNHJIrXmhF5Pr68gMO000NV0x4iPn0aW2vIucGig9l6p5MJnTB63ZNuUeTvL3xP7j1mydcouYRh2fPlSkXnjq42bzczgWqYd1zbssjQ/aprtVQzpXlDyY8mMQ5VJgV/OSMhG/n4CaCD9ZYZ5tnY9PHypSR/SF++BasY87G7mKL/ap7fXECuLaqjWwezCVeTTV8pJSxFOVBFui/senDxWpD/rC3Xem2Mc9kq/PAFU5IsMMJtBdQ0zVsXs0yYxpb2bavaS8sonj04eK1BFPTeXosU9x7NmjOgtXeizJpp8lBNFMFOVsIrLBkaIado+m6l5S3tjk8elDReqEnnCfp3HjgVoXrN77F27t/LA+vspFzEGrkgjyxqhzdCyPdQcLl2SffYDH5tGk4yWlQeOOTx8qsjn0hPvBbizPlL7HPb3Yg+88uz1ao6C2jGpvIrognhrBgmquGo6LRYHreEnVpq7Hpw8VqSMBndZnjrgujKxrjD57odHHJxJO6+O0PkICgxSsXCRSsF6SGoVLiA/ITLtxcQMdMIhvWMEaxtioJFQ3fwd6ThHfsDynwoYUaCXhutFI29raWkMzruT27dvo7+9XJUJM3DYP3xechOsq41K4xE9EVw0dHR2qFB4oXBJowipcC6/3z1FlQgIIhUtIAKFwCQkgHoSbw4Tor07kVJEQ0nRcC7cwPYVZtU4I8Qd3wi1M45tMDKeOqDIhxBdcCLeA6W8yiH12Eu1qCyHEH7SFm5sYRib2GU5StYT4jp5wcxP4Cp/ja6qWkBYA+D+dP8wxS9wuAwAAAABJRU5ErkJggg==)
Tryck Ctrl+E (snabbfyllning)
Om du har tur så fattar Excels AI "mönstret" och hämtar precis det du vill. I det lilla exemplet antar den att mönstret är inledande siffror.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAPwAAABdCAYAAACB6wssAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAA20SURBVHhe7Z0PbBPXHce/KStat25NoEyiKQuDmEksSJ22IGKriA1pjcPWAkVeJYbSidVeVY14o4yuCt1Gsq6MdrXTTmuCkFZ1qJ3bEtgWm4p1jdLZQUEd3YgyKQ60IbhoY0D6B1GlK9l7d+/OZ+Ozz459Z+d+H+kp9+5d7k/8vu/33ju/b6omJyenQRCELbhO/CQIwgaQ4AnCRpjSpZ+enkZVVZXIEUSS8fFxVFdXi5z9YPpDXV2dyJUeUyI8FzxBZOLq1atiy56Y/fymCN7uHyqhDwl+FgqeIjyhBwl+Fgh+ampKbMlQhCf0IMFXuOC52C9fvixyMhThkwx1bcKmriGRI6wR/Jt4rOs+rFHTbrxwURSZTEULPpPYORThBYlehM6sxuozx0CSl7GubizC97+zD/3bWFpXi2ciEUyIEjOpWMHriZ1DEV4mMRQFXHfjbtcZhHoTYq+9KYtgUHMLlolNs6lIwWcTO4ciPCcBSe8ra1G70gVEh9geohzqxsSp48Cy21jMN5+KE3wusXMowjMSQ4jCBaZ3MMWzrSiGSPEWCn4Cz/xeHsNvGW3ErsaFYr+5VJTgjYidQ4JXuvMrwfXOFA85yJPirRO8Zgy/6h1s6dqPmCgxk4oRvFGxc6z7UMuFIbx84G28faANmzZtklKblH/Z9pN3ZVE3ln4FzWyAdcaCmfqKEHw+YufYPsIPHcPA4s0IvvQSXlJTEJsXD+CYzRVfFoI/9QaOsF7X5+eJvImUveDzFTvH7hF+6NgAFqvdeQXerV+MAZsr3rq6kRzDr+lLsO79VjhFiZmY/fx5rZbLR+w1NTViCzh//jwWLFggcgSRJBqNoqGhQeTsx/DwMFwul8iVHsMRvpDIrmD3CE/oY/e6YfbzGxb83LlzpahtNGmhWXpCDxJ8mQp+JlCEJ/QgwZv7/KY43iQSCdTWpk5ZEcSXOzxiizixKyS2SkvV8PDwNG9leOJdb6PbRo/dHn1GutCvVt0n/SQIhR8f2ye2CLP0UTU+Pl7SCM9fe3BOP/6K9JMgFJY8eIf00851w+y/gSljeIIgygMSPEHYCBI8QdgIEjxB2AgSPCfiQ5UriDGRrQgq8Z4Jy8lT8LL5n/f4OZEvnLGgS/pvNK6gtsqOIeiqkvaryRcRZQRRvlRKfTYs+Inju7Gm6w0sbpqpEVAEPvbgrWhHQGd5kjc8Lb3Dl1K3W+wliHKksuqzYcEvanwE/du2YubretzoZg8ebXOIfIGMBeHStJzJhlNuVX0R+YOQy11IbXi1v8vKRsV+lfSW2cc+VgV+XvY7Qdal1pQpLbx6zkx97Qq5Z/1nyXYNA88wKylSfTaJshzD97TkqjCsUrUCz4pWM86a1p7O1PFsT0snlsfl8rA3Bv9epWqyitnqBwJx0eq2Y8TfI8pkIj4H/A1hUc7PP4yWlPEyOx87RVgq74abibHV3yDyPEXRVi8OVamQe9Z9Fi7oDNdIEX22Z7AvueuzeZSZ4OvRFlUqGq9QgN+RWqFkWKsabWNHy9Sv88AZG0Fc5DnecFJ07vVeYHhUrvxjfQjFvGhXFcnOFWblCqzCd/Y4EdiR7HrVt7XDGwuhT/NhecNMNGJbpgeHstbtSrrnDPvFPYQ1XVLpGhjGaMo1dJ7Blhitz+ZRlhFeQa5QmStlSrfT4TduQBgfMXAsi0wOpVXmqYXdRRbq2xBln+awaMlTJ26SVMQ96+3PeA8OLHfGMKJttQhdstVnsyhrwWNslMUPJ5anD48iPji03U5WQQ3bEzmWGziWRTLl3GpKRq6McKFIx4XR4HdoxueCSrrnTPsz3kMcI7EMnw+RGb36bCJlJfiIL3WME9nLoqDTg3XZKi1DOk5s56R+GRpYK9upXIh1h10tmlhYvw4ep6Y8b3jUE5tZqIx71uwX12jRtGRjwU70GPh87Eqh9bmUWCB4ZRbXAT+r8TEWQZSuo3t9Q0q3tGU4gLhm3Kvi7kbYyyqfOK5zeYDFN6Ow8S+LruxC8nUcI2hPibZ83BWHJyTKlZTtSy78SzDqsfLE1jVvXyrlnnWfhV8jDG9Pi1ruCHkyfz62ogj12URoeSxhGbQ8lpbHEgRRQkjwBGEjSPAEYSNM87R77QdZ3woTNuRrT8nTlnz82tvbK23biQ0bNqhjeLP0QZN2hGVoJ6wGBwelbTvR1NRk+qQdCZ6wDBJ8UvDFdq3l/6E4EyR4wjJI8KmC37hxo7Q9Uw4ePKgreJq0I4gy5L3Xfo3xtjlq+vdTXxclM4METxBlxkfnx/DuXx5D9dpvo2bdvbhu7g2Yd0/qpN5N33sec7x/xu23u1JSLkjwBFFmvHv0F7i++mZ8qmEVPhh8BTe17Mb1C5JfyH3+H+9h55Zmabu/f0BNRjAseNniSvwD/a79xhd+ZCDVUUXr/EIQs4uzIR+cTqea9uSYqvjw1Ou4cuJFfKbpG5h89Q/46OI5XDq0A//p/pZUfmT0Mt6a/FjaLgSDgn8TBy7cif5t+6T0XFMCDx95U5TlCXdU4YsupuUlnJLzS4u1pgAEURLOhtDx6lqEYjHEWAr5V+Dw9j3IpvlLvT/C1akr+O+LT2HOp2/CDV/8KubWfgmf8/0Jg2eu4O/npsSRhWFQ8LfhoebbxDawaGkjll04hwmRzwu+1jrd+SXNNSWJvodaxMfyKV0D+VjVsIEvITXUiyjNNcgvjsCtHnR3e3CrknWuxQqcxsRZsSMDCx88jvlsvD7nxhop/78L53Hzdw/i6cODWPvLv2LXgaiaOD/d9bCajFDYGP7SOxidvxAz9a+VkJxUGrAsw5rBbD5tkn1Sz6GkKCQLJic80mLj3P5xCiW5Bu/FkF8ckc7EWziJJViktAA6vP+3p1lUX4zLJwZQfefj+MTNS3H/N1fi/aebMfVbt5o4P+94VE1GyF/wFyPw9gGPaiJ+4bCK3tkDZ2BHmtcag4kjq0+be32KXdBYX0hjLpDbP06ipNfQszLKsJ/84mzAWYR+dxgr/JvRJPZk4oPB/Zg6+098ePpfqNkYxJXa1VIDXyzyErw0cccq665tWzPYHeWPFF0RwLO6PkzZfNrckAMwV88Y+kIxeNuTAjTuH1eCa+j5wuntJ7+4Wc/gHg+r6X7s8mQP7++LtSefXbsDNzZtxR17+60RPBd7B+5D/2Z3UbryfHyc2wEku0+be0cATt7lFhFyvRIg8/KPK9E1yC+OEAzucWL7aT9CmvG8HnwMXxf8GNXun0kL0E5c+qQoKQ7GBM+68R0X7kRP40KxYybIE1A5xW7Ep005ppV1tb3rrx0WCHT948y4BvnF2RjWjfcZFzuHf3mm/eGdUnqk/SfSvrn3RzImTmkm7fgk3ehvNO/hedqNFy6K8nyI7JW8vxDzw6F0h3lKmQ3nGPFpq8c6j1N65eFVQy/DsH9cia5BfnEEZ/AAAifZz5MB1qAn38U7c7yMT5+I007UaRMn/dhc0OIZwjJo8cy1i2d4hNd+a45HckXc6aSXrVmzGq+/HqXFMwRByJDgCaLM4JFaSRztuF2bOOnH5oK69IRlUJfe/PXw5GlHWAZ52iU97Yot+MbGRpFLhSI8YRkU4cniirARJPik4M3SB03aEYSNIMEThI0gwROEjSDBE4SNMCz42BHN9+gPRApzu9GgLC1Vl4imIbnNZCkniHJC8a7zhTLb2fAVc9nKzcKg4M/hzPwHVE+7R+cfxJZCPe24UwwTcivaEdBbsxrxoWXYC69eOUGUDYPYw4TcgXvhXyF2pTO4B9tP34W79MpNxKDgF+KexqTDjdOxSmwVghvd09OItukt9JZdcLztO7Bc7LkWvsSWe7pl83iTl+Eqq89SPeL477Hjg8rqtVQrqVKdn3zuZiNN2BmLoduj5xIhO93cde9mfEHssZKCxvCx+DE0O4phcXUtY8FWzbLRbHCnmqTHWzwAlk8KIptXnQz7fT+EgUV3hnXuRT4/+dzZkrOhDgSWPIGd2XytTMS44E/tV8fwA459eGip2F9MlMqfW+0SWo+3FA+4XF51Am84k9CTFP/85HNnK7hNdWAJnigXtTOMC37pVnUMvzpenIm7VFhEa/WjIYcIs6P1gOMRWtsd1nrVFcoMzk8+dzaDdeU7AljyxM6sppVmU1CX3tn8AJovvFNkwXMPN95FVQTEurMsH/M70hxosqH1gMvuVVcYMzw/+dzZiAm8dRI4vF1xuvFI7jcnAx44fSHWHFiDMcFfjOCFU2KbMXH8jzgy/5bi+NKryJN5SfHEpVl8ZyCOaR2rp54W7cSXxgPOiFedAUp3fvK5m/3Ik3ncGk1OIWkWf4U/hJhBf7tSYEzw8xbi7b7ke/gto414rmD3WmVWWRPBtV3ZPPCG2zEiutWSg6zaMBjxqstNUc9PPnezFPm1XEoEZ3mr37frUaGr5eQZ7JH2aQOz+YVQ6vMTHFotR6vlCGLWw4XOE4cL3Syxc0jwBGEBPLKnJzMgAwzCMpRKbse6kUngZvwdyNOOsAzF085ucGFnErwZGqmanJwsaYTnHD16VNdji7AvZnVjyw09wZsS4UnwhJWwISXq6upEzj6Q4AlbYlfBK5j9/DRLTxA2ggRPEDaCBE8QNqIAwQ+hi43Hu4ZEliCIiiFvwSd6Q0j+92qCICqJ/ASf6MWTURc2G/vPtARBlBl5CD6B3iejcP1wA2rFHoIgKgng/9fBIY+HeCQBAAAAAElFTkSuQmCC)
2) Text till kolumn (i ditt exempel skulle det funka)
Markera kolumn A och gå till
Data->text till kolumner->
Fast bredd eller avgränsade fällt med mellanslag som separator.
3). Formel (om det är exakt 15 du letar efter, inte inledande siffror)
=OMFEL(EXTEXT(A1;SÖK(15;A1);2);"")
Etc. Det finns en massa metoder, men inte mönstermatchning (som du egentligen frågar efter)