Generate a filename from cell's text content

[epouepou]

Hello!

First of all, I'm new with Excel, so sorry if this is an impossible request.
Can I have in column E a text generated from the A,B,C,D cells
separated by "_" and a ".jpg" at the end?

xcel.jpg

[Moo the Dog]

Try this:

=A1&"_"&B1&"_"&C1&"_"&D1&".jpg"

- Moo

[epouepou]

It's PERFECT!!!!!
Thankyou so much man!!!! ^_^

[Moo the Dog]

Glad to help =)

- Moo

[epouepou]

In some raws, I have no data. So it writes the "__.jpg"

Is there a way to modify the formula you already made so that:
if those cells have no text, then it leaves empty the filename cell too.

[Moo the Dog]

You can try:

=IF(COUNTA(A1:D1)=0,"",A1&"_"&B1&"_"&C1&"_"&D1&".jpg")

- Moo

[epouepou]

It's perfect, Moo!!!
THANKYOU!!!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

[epouepou]

last thing guys, sorry...

Is it possible to have the filename not display also if there is a "/" in a particular column?
In that case, if possible, to write to another column "cad."


So in the attached xcel file it would be:
If D has "/", empty J and write "cad." in G

[Moo the Dog]

Put this in J3 and fill down:

=IF(OR(COUNTA(C3:F3)=0,D3="/"),"",C3&"_"&D3&"_"&E3&"_"&F3&".jpg")

Then put this in G3 and fill down:

=IF(D3="/","cad.","")

You can also change your formula in K3 to this and fill down:

=IF(I3="","",I3&".eps")

- Moo

[epouepou]

I'm having problems with this, moo (maybe because I'm working on Google Spreadsheet)
I also tried to put the formulas in NeoOffice Calc (I can't use Excel right now).

I'm sure the formulas are correct, it seems there's an incompatibility between these programs.
Is there a way to convert xcel fomulas to work on other like-software. Found nothing online..

Anyway I'll keep the formulas and try to find a way to open the file in Excel.
Thank you very much, for the time you put helping me Moo!!!

[epouepou]

in Excel the same problem: J and G not working.
K is ok (thanks for correcting mine)

[Moo the Dog]

See my attached file - they seem to work perfectly.

- Moo

[epouepou]

OK, I see the problem.. maybe I badly expose the question then. So excuse me for not being clear.

if the "/" is in D even if there is other text in D, to leave empty the filename cell.

G also gets "cad." if there's "/" (with or without other text) in D

[Moo the Dog]

OK, change the formulas to:

G3:

=IF(ISNUMBER(FIND("/",D3)),"cad.","")

J3:

=IF(OR(COUNTA(C3:F3)=0,ISNUMBER(FIND("/",D3))),"",C3&"_"&D3&"_"&E3&"_"&F3&".jpg")

Then fill both down the columns. Should hopefully work how you want it to.

- Moo

[epouepou]

IT'S IT!!!! XD
THANK YOU SO MUCH!!!!
Can't thank you enough Moo

[Moo the Dog]

Glad to help