Concatenate with / and space

[monkeyfool]

Hi all

How can I get this text in my cell?:

C3 cell text/Airport C3 cell text​

Here is my attempt

=CONCATENATE(​

​

​

​

C3;" ""Airport")​

Thank you

 

[Jonmo1]

Welcome to the board...

Perhaps

=C3&"/Airport "&C3

 

[njimack]

=C3&"/Airport "&C3

 

[monkeyfool]

Thanks jonmo1 and njimack that works great. I have just pasted it into 4,000 rows and it works great. My question now is how do I hard code the results from this formula- I have the results from the concatenate now I want to get rid of the formulas. Thank you

 

[Jonmo1]

Glad to help, thanks for the feedback...

To remove the formulas and leave the resulting values...

Copy the column of formulas
Right click - Paste Special - Values


Hope that helps

 

[monkeyfool]

Great thank you!!

 

[monkeyfool]

I just realized I have it the wrong way around it should be:

C3 cell/c3 cell Airport

how can I change it please? Thank you

=C3&"/Airport "&C3

 

[Jonmo1]

That would be

=C3&"/"&C3&" Airport"

 

[kpark91]

= C3 & "/" & C3 & "Airport"