Dears,
I want to add country code from cell A1 in front of each area number in Cell B1( the numbers in Cell B1 are separated by a comma).
This needs to be done to a large number of data thus want a formula for it. thanks
country code.xlsx
Dears,
I want to add country code from cell A1 in front of each area number in Cell B1( the numbers in Cell B1 are separated by a comma).
This needs to be done to a large number of data thus want a formula for it. thanks
country code.xlsx
Use
=A2&SUBSTITUTE(B2,", ",", "&A2)
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
In C2, try:
=SUBSTITUTE(SUBSTITUTE(LEFT(" "&TRIM(B2),LEN(TRIM(B2)))," ",A2),",",", ")
and copy down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks