Create filename from three cells and get to clippboard
 

Hello.

Can someone help me ?

I need how to create filename from three parts. Each parts is in one cell
(example A1=ProductCode, B1=StartProduction, C1=EndProduction). And i need
this created filename get into clipboard for use out of Excel. (exporting to
PDF and just push Crtl+V on saving PDF file)

Create filename from three cells and get to clippboard
 

Well, to put the three cells together, you would use the following formula.

=A1&" "&B1&" "&C1

then you would have to click on this file name, hit ctrl+c, then do your
export and do a ctrl+v

"Booker" wrote:

Hello.

Can someone help me ?

I need how to create filename from three parts. Each parts is in one cell
(example A1=ProductCode, B1=StartProduction, C1=EndProduction). And i need
this created filename get into clipboard for use out of Excel. (exporting to
PDF and just push Crtl+V on saving PDF file)

Create filename from three cells and get to clippboard
 

Thanks for reply.

It looks helpfull but isnt, in cell B1 and C1 is date.

Result is "DA016-0O 38668 38668"

Create filename from three cells and get to clippboard
 

Try this

=A1&" "&TEXT(B1,"mmddyy")&" "&TEXT(C1,"mmddyy")

change date format accordingly

--
Regards,

Peo Sjoblom

(No private emails please)


"Booker" wrote in message
...
Thanks for reply.

It looks helpfull but isnt, in cell B1 and C1 is date.

Result is "DA016-0O 38668 38668"

Create filename from three cells and get to clippboard
 

I don't know why, but formula above is'nt working for me (maybe beacause my
version Excel Czech ).

So, now i have three cells and macro which is copied into clipboard and then
i will paste after PDF export as filename. Problem is "141105 141105 DA016-0O
(N823)" the name of file is'nt valid beacause small squares between dates and
name (not visible here). Haw can i remove this squares, maybe tabulators ?