|
About Find & Replace...
Sir...
I want to now "how to add the numbers or text in single cell?" that the cell already contain values......? mean... I have cell with value of 401A in B4 and 501A in A3 Now I want replace to just add 1 before the values (e.g 1401A,1501B)... How to I can change these values automatically.... at single attempt ..... I also tried "?*" and other option it not working... can you please help to me..... |
About Find & Replace...
Hi,
let's assume your numbers are in column A in B you can enter ="1"&A1 copy formula down "sasi excel help" wrote: Sir... I want to now "how to add the numbers or text in single cell?" that the cell already contain values......? mean... I have cell with value of 401A in B4 and 501A in A3 Now I want replace to just add 1 before the values (e.g 1401A,1501B)... How to I can change these values automatically.... at single attempt ..... I also tried "?*" and other option it not working... can you please help to me..... |
| All times are GMT +1. The time now is 04:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com