| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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..... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
Linear Mode
