Add function to text string

Hello

I would like add a function to a text string, the function is:

=MID(A2,FIND("-",A2)+1,FIND("-",A2,FIND("-",A2)+1)-FIND("-",A2)-1)

The function needs to fit at the end of the string which reads:

General arrangement of Signal Post (and the function goes here)

Thanks in advance for your help.

you just need to encase your string within quotations and concatenate (c/o & or CONCATENATE function)

an alternative, using the ampersand approach but with a SUBSTITUTE approach to retrieve 2nd element in hyphen delimited string (A2)

="General arrangement of Signal Post "&TRIM(MID(SUBSTITUTE(A2,"-",REPT(" ",255)),255,255))

Hi
Thanks for your help.
If number 2222-01 is in cell a2 the output is GENERAL ARRANGEMENT OF SIGNAL POST01 THUS i NEED A SPAVE BETWEEN THE LAST WORD AND THE 01 NUMBER.

Thanks Again.

Hi, with above referenced value in A2, the formula per post 2 will return "General Arrangement of Signal Post 01" (note the trailing space in the string, prior to ampersand)

if you want this in Upper Case then (without knowing variant content in A2) apply outer UPPER

=UPPER("General arrangement of Signal Post "&TRIM(MID(SUBSTITUTE(A2,"-",REPT(" ",255)),255,255)))

Thank you XLent, it works perfectly.