How to add prefix into cell values in excel Google sheets?

How to add prefix into cell values in excel Google sheets? Sometimes we need to adding prefix country code number to phone number in excel o...

How to add prefix into cell values in excel Google sheets?

Sometimes we need to adding prefix country code number to phone number in excel or Google sheet by text function or formula.

Like if you have typed some numbers 1,2,3,4, ...  but they are the symbol numbers and need to start from 401, 402,403,... , here are the easy steps to add the prefix in the Google sheets.

Steps

1. insert a column as needed.

2. in that column, in the first cell add Formula = TEXT(A2, "400")

3. drag the column to apply to all the cells.

Done.

See the result below.