CSV File name to show in A2

[bobaol]

Hello, how do I get a .csv file to show ONLY the file name in A2? and if possible, to show the sheet name in A3? I currently use =CELL("filename") in A1, but that comes up with C:\temp2\6489\TankMan.csv However, I do not want the full path, I only want the file name. Any help is appreciated. Thanks in advance.

 

[rlv01]

=TEXTAFTER(A2,"\",-1)

=TEXTAFTER(CELL("filename"),"]",-1)

 

[Joe4]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Cubist]

Which Excel version are you using? Should update that in your Account Details.
Edit: @Joe4 beats me to it

 

[bobaol]

worked perfectly. for non-Excel files =TEXTAFTER(CELL("filename"),"\",-1) for Excel file =TEXTAFTER(CELL("filename"),"]",-1) Thank you everyone. I love MrExcel and all y'all. U D best!

 

[bobaol]

Hi, just wanted to share this issue. Earlier, life was perfect with the Textafter function. However, 8 hours later, the Textafter function no longer appears on my version Excel. Weird. i restarted my machine. Redirecting
Anyone with any ideas on why a function simply disappears? Is it this MS Enterprise License issue, where a person would have to pay to get certain functions to work in one version, but if not paid, then the other versions will not support the function? any help is appreciated. thanks in advance.

 

[rlv01]

That's strange. However with Excel, there is always more than one way to do something.

tmp1.xlsm.xlsx
	A	B
1	C:\temp2\6489\TankMan.csv	TankMan.csv
2		Sheet1
Sheet1

Cell Formulas
Range	Formula
B1	B1	=TRIM(RIGHT(SUBSTITUTE(A1,"\",REPT(" ",100)),50))
B2	B2	=TRIM(RIGHT(SUBSTITUTE(CELL("filename"),"]",REPT(" ",100)),50))

 

[bobaol]

Works. learning new stuff all the time. really appreciate it. Thank you!