Thread: how do i add same prefix any text or number to the large datas?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
how do i add same prefix any text or num how do i add same prefix any text or num is offline
external usenet poster
  
Posts: 1
Default how do i add same prefix any text or number to the large datas?
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.
Reply With QuoteReply With Quote