Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help me is it possible to add to multiple cells without changing t
I need to add "ca" in the begining of all 3000 cells on my worksheet without
changing the data that is in the cells already is this possible without editing all 3000 cell indiv please help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help me is it possible to add to multiple cells without changing t
Try on a spare copy ..
Assuming data running in A1 down In B1: =IF(A1="","","ca"&A1) Copy B1 down to the last row of data in col A Then kill the formulas in col B with an in-place: Copy Paste special Check "Values" OK. Then delete col A -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "wishing well" wrote: I need to add "ca" in the begining of all 3000 cells on my worksheet without changing the data that is in the cells already is this possible without editing all 3000 cell indiv please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems comparing data from multiple blank cells | Excel Worksheet Functions | |||
count 2 nonblank cells on multiple worksheets | Excel Discussion (Misc queries) | |||
link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
how can i ignore blank cells when multiple cells? | Excel Worksheet Functions | |||
Formula to delete blank cells across multiple columns? | Excel Worksheet Functions |