Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to replace cell
Hi,
Would like to fill in a blank cell with something, it located in another area of the list, it looks like this, **** means blank cell merchant 1234 Totals **** I would like to put the merchant number next to the total cell. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to replace cell
If your data is in A1 thru A3, then in B3 enter:
=A2 -- Gary''s Student - gsnu200907 "Bklynhyc" wrote: Hi, Would like to fill in a blank cell with something, it located in another area of the list, it looks like this, **** means blank cell merchant 1234 Totals **** I would like to put the merchant number next to the total cell. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to replace cell
it works for the first batch, but my list continue on about 40 to 50 batch
and some batches has more lines which look like this merchant 1234 1234 1234 1234 Totals **** is there a formula? "Gary''s Student" wrote: If your data is in A1 thru A3, then in B3 enter: =A2 -- Gary''s Student - gsnu200907 "Bklynhyc" wrote: Hi, Would like to fill in a blank cell with something, it located in another area of the list, it looks like this, **** means blank cell merchant 1234 Totals **** I would like to put the merchant number next to the total cell. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to replace cell
Hi,
You essentially want the blank cell to be equal to the value in the cell one cell to the left (of the blank cell) and then one cell above. Select the column which has the blanks and then do Ctrl+G Special Blanks. This will select all the blank cells. Now press the left arrow key and up arrow key to select the cell. Now press Ctrl+Enter. Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bklynhyc" wrote in message ... it works for the first batch, but my list continue on about 40 to 50 batch and some batches has more lines which look like this merchant 1234 1234 1234 1234 Totals **** is there a formula? "Gary''s Student" wrote: If your data is in A1 thru A3, then in B3 enter: =A2 -- Gary''s Student - gsnu200907 "Bklynhyc" wrote: Hi, Would like to fill in a blank cell with something, it located in another area of the list, it looks like this, **** means blank cell merchant 1234 Totals **** I would like to put the merchant number next to the total cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Find & Replace one cell w/another cell unequal occurrences | Excel Discussion (Misc queries) | |||
I can't see Highlight cell in Find & Replace Cell | Excel Discussion (Misc queries) | |||
Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
Excel - create button to replace cell content with cell value | Excel Worksheet Functions |