| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
New User: Copy Cell and Insert into Cell of Text.
Hi,
I'm looking for some help on which formula to use (if even possible): If you look at the attachment, I have a set of data in column B that I want to copy and insert at the start of column A (which already has text in the cell). What I really need is the data from column B inserted at the start of column A, and even better if we could put it in brackets with the postfix "mins". Attachment: Rows 1 & 2 are how the data currently is. Rows 4 & 5 are how I would like it! Any help would be much appreciated! Tks Tom |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
New User: Copy Cell and Insert into Cell of Text.
Hi,
Am Tue, 6 Nov 2012 13:13:00 +0000 schrieb tomvcarter: Attachment: Rows 1 & 2 are how the data currently is. Rows 4 & 5 are how I would like it! try in A4: =A1 in B4: =B1 in A5: ="("&B2&" mins) "&A2 Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keep Cell Unlocked but Don't Allow User to Change the Text in Cell | Excel Programming | |||
| User Form texbox insert text in cell - excel 2003 | Excel Programming | |||
| how do I insert user name into a cell | Excel Worksheet Functions | |||
| How do i insert my excel user name into a cell? | Excel Discussion (Misc queries) | |||
| Insert cell/format/text/fontsize and auto insert into header? | Excel Programming | |||
Linear Mode
