convert a concatenated string to an absolute string? 11

[loganswell]

Hi,

I feel sure this should be possible in Excel! ...

If cell A1 has value "Hello" and cell B1 has value "World" then in C1 you can enter the formula =A1&" "&B1 and get "Hello World" to appear in C1.

However my question is... How do I make the reference "Hello World" a permanent string value instead of the formula.

I hope I have worded my query properly. I cannot think of another way of expressing what it is I want to achieve.

Many thanks!

Jim

 

[loganswell]

Yes, this certainly HAS generated a lot of responses and I'm grateful to all the contributors! I was sure that it could be done as I'd done it before years ago but just couldn't remember what it was I did! The memory goes with advancing years.

I do wish that I was clever enough to use VBA to manipulate the data on Excel sheets but it all seems a little over my head! The fact that I am labelled here as a "programmer" is slightly fanciful.

Thanks again guys - I handed out some stars before and hope that I didn't leave anyone out!

Best wishes - and as big Arnie would say.. "I'll be back!"

Jim )