how do i add same prefix any text or number to the large datas?

  • Thread starter how do i add same prefix any text or num
  • Start date
H

how do i add same prefix any text or num

For ex: In a column 1000 chech no is entered.
100100
100101
100102
I want to add prefix Ch. No. to all 1000 numbers like below
Ch. No: 100100
Ch. No: 100101
How to add this to 1000 of ch. no. which is the shortest way to do this.
 
J

Jacob Skaria

A1 = 100100
In B1 enter the below formula

= "Ch. No: " & A1

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prefixing a number to the number in a cell 2
how do i use vlookup and add all the results in pulls? 2
Convert Number to Text for Index/Match 1
How do I separate the alpha prefix from a text (abc123 or a1234)? 1
adding a text prefix to an entire column 2
copy specific data to another worksheet 14
SUMS 1
How do I reference contents of a cell at the bottom of a column? 2

Top