| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have data in cell A1, I want to add data to it from cell B1.
Can I have help with a formula to get data from B1 to A1 without losing what
is in A1 -- Zippy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have data in cell A1, I want to add data to it from cell B1.
I dont think you can !
Instead, why dont you use a formula in A1 which will take data from B1. The existing Data in A1 should be entered another cell. (assuming C1) So, formula in A1 wld be =C1&" "&B1 . (remove & " " & if u dont want a space in between.) HTH, -- Tausif Mohammed "Zippy" wrote: Can I have help with a formula to get data from B1 to A1 without losing what is in A1 -- Zippy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have data in cell A1, I want to add data to it from cell B1.
Thank you Tausif, I will give it a go and let you know.
-- Zippy "Zippy" wrote: Can I have help with a formula to get data from B1 to A1 without losing what is in A1 -- Zippy |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have data in cell A1, I want to add data to it from cell B1.
Hi Tausif, You may be able to help me with something else. Cell b1 has
address data, eg: 25 Map Rd, Fredsville, 1111. I want to divide this into individual cells. Hope you can help -- Zippy "Zippy" wrote: Can I have help with a formula to get data from B1 to A1 without losing what is in A1 -- Zippy |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have data in cell A1, I want to add data to it from cell B1.
Menu DataText To Columns, with a delimiter of comma
-- __________________________________ HTH Bob "Zippy" wrote in message ... Hi Tausif, You may be able to help me with something else. Cell b1 has address data, eg: 25 Map Rd, Fredsville, 1111. I want to divide this into individual cells. Hope you can help -- Zippy "Zippy" wrote: Can I have help with a formula to get data from B1 to A1 without losing what is in A1 -- Zippy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting numerical data in one cell to word data in another cell | Excel Worksheet Functions | |||
| how to find number in a cell , a cell contains character data ornumeric data | Excel Worksheet Functions | |||
| moving data to a cell, not pulling data to the cell | Excel Worksheet Functions | |||
| cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
| Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data | Excel Discussion (Misc queries) | |||
Linear Mode
