Auto Populate Some Info

Hi, I’m trying to find out if I can input a file name such as “file name_123456_2018_NI” into one cell and have just what is before the first underscore appear in another cell. The file name does have a space between the first part, as in my example “file name”, if that is relevant. If this can be done, what is the formula? Thanks!

By: Suzanne

Leave a Reply

Your email address will not be published. Required fields are marked *