Hi,
I'm using Excel 2016 to create a form, I am a novice and I'd like to know...
I'm trying to find out if I can cut and paste a file name such as "file name_123456_2018_NI" into one cell, have it stay there where I paste it and have just what is before the first underscore populate another cell. The file name does have a space between the first part, as per my example "file name", if that is relevant. If this can be done, how do I go about doing this?
Thanks!
I'm using Excel 2016 to create a form, I am a novice and I'd like to know...
I'm trying to find out if I can cut and paste a file name such as "file name_123456_2018_NI" into one cell, have it stay there where I paste it and have just what is before the first underscore populate another cell. The file name does have a space between the first part, as per my example "file name", if that is relevant. If this can be done, how do I go about doing this?
Thanks!