How to make rumble of pairs

[sun_ilkumar]

A1 b1
10 001-011-012-013-014-015-016-017-018-019
11 011-111-112-113-114-115-116-117-118-119
12 012-112-122-123-124-125-126-127-128-129
13 013-113-123-133-134-135-136-137-138-139
14 014-114-124-134-144-145-146-147-148-149


how to make the 3 digit rumble numbers from the pair of colum a in colum b

[khamilton]

I dont understand,

[zbor]

Select B column -> Data -> Text to columns -> Delimited -> in Other box write - -> Finnish

Select all -> right click -> Format cells -> Custom -> Write 000

[sun_ilkumar]

thank you sir