Populate Another Cell with Some of the Data From Another?

[SMAsh67]

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!

 

[Roderick_E]

=left(cell,FIND("_",cell)-1)

 

[SMAsh67]

=left(cell,FIND("_",cell)-1)

I am a novice and have no idea how to use this. Though I do appreciate your quick response... what do I do with this?

 

[Roderick_E]

I am a novice and have no idea how to use this. Though I do appreciate your quick response... what do I do with this?

No worries. Say you post your file name in cell B3. in an empty cell you put in my formula:

=left(b3,FIND("_",b3)-1)

It will return the file name up to the first underscore _

 

[SMAsh67]

I'm trying this out and it works great (thank you!) except I put in =LEFT(F8,FIND("_",F8)-1) and when there is no data in cell F8 I get the error #VALUE !

Can I get rid of that error or hide it in some way?

 

[Roderick_E]

I'm trying this out and it works great (thank you!) except I put in =LEFT(F8,FIND("_",F8)-1) and when there is no data in cell F8 I get the error #VALUE !

Can I get rid of that error or hide it in some way?

=iferror([COLOR=#333333]LEFT(F8,FIND("_",F8)-1),"")

[/COLOR]

If nothing in F8, it will return nothing

 

[SMAsh67]

You are a magic! Thank you so much!

 

[SMAsh67]

You are magical I got so excited I typoed LOL!

 

[SMAsh67]

I'm very grateful for your help! This works perfectly...

=IFERROR(LEFT(B11,FIND("_",B11)-1),"")

I was wondering, is there a way to make it show everything after the last "_"? I've been messing with it but I just can't get it to work.

The file names are never the same length. For example:

random name_17075496309_9863-7-3_9-36-27_GMC
thisone here_98634961630_1213-9-10_11-53-59_NC

But they always have 4 underscores. What is after the last underscore varies from 2 to 3 letters.

Is this possible to do?

Thanks again!