Hi there, I apologize for this question but I hope there is an easier way to do this rather than deleting everything one by one and manually inputting everything in again.
So my scenario is that I have in column A, for example:
4'5" x 9'3"
And then I have hundreds of rows below this with different measurements like this one.
But for database reasons I want to move all the individual numbers into a different column. So I want the 4 (without the feet sign) in column A, I want the 5 in column B, I want the 9 in column C, and I want the 3 in column D. Again, without the ' and " signs.
And of course, this has to go down hundreds of columns. I'm really not sure if this is possible. But if someone can give me an idea of how I can make this process easier on myself, I would be forever grateful. Thanks!!
Bookmarks