Avatar of Kim Hart
Kim Hart
Flag for United States of America

asked on 

What is the best way to split information in a cell that contains numbers and words while keeping the words together?

I can split this up using text to columns but it put the information in 5 different cells. Is there a better way to just split the numbers from the letters? I have a lot of data to manipulate and only want the letters for description
0013976475 00001 Chip Mill Maintenance
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Tom Farrar

8/22/2022 - Mon