seprating words from numbers
in a column if cells have number and alphabets together eg
123abc abc123 ab134 a12 is it possible to seperate number from alphabets Thanks for your help |
If the different combinations are grouped- for instance, all the 123abc
types are in one place, all the ab134 types are in another place- you can use functions such as MID, RIGHT, or LEFT to separate them. (By "types" I mean the first x columns are numeric characters, and the following y columns are alpha characters.) If they are mixed and cannot be grouped then you'd need VBA code to perform the separation. |
All times are GMT +1. The time now is 05:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com