I want to take some of my cells that look like this:

PETROLIA ONTARIO CANADA NON1RO,
VANCOUVER BC V5L3B1,
ONTARIO CANADA LOR2C0,
DN58BY ENGLAND,
DN58BY ENGLAND, 

and change them into this:

(intl) PETROLIA ONTARIO CANADA NON1RO,
(intl) VANCOUVER BC V5L3B1,
(intl) ONTARIO CANADA LOR2C0,
(intl) DN58BY ENGLAND,
(intl) DN58BY ENGLAND, 

Is there an easy way to do that?

4 Answers

use the CONCATENATE formula. the below example assumes your first value is in cell A1.

=CONCATENATE("(intl) ", A1)

2

I think using the concatenate function requires unnecessary typing. Just use the ampersand sign to concatenate values:

="(intl) " & A1

I think that's easier.

If the above data is in cells A1-A5, you can get the desired result if you put the following in cell B1:

=CONCATENATE("(intl) ", A1)

and copy-paste it to B2-B5

1

You can copy the following into the first column of the next and drag the bottom left corner of that cell down:

=CONCATENATE("(intl) ", INDIRECT("RC[-1]",0))

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy