| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to cut part of a text from one cell and automatically paste itonto another cell
Hello,
Please see below example: I have column A1 which has information CHI090169094 BKG# 19802749 and I want to extract BKG# 19802749 and put it into column B1 and delete the information that was in A1 for BKG# 19802749. Can someone advise how I can do this. I tried using the formula =LEFT (A1, 13) and it captures CHI090169094 and pastes into B1 column. But That's not what I'm looking for. I would like for the formula to capture BKG# 19802749 from A1 and put it into column B1 and delete the information that was copied from cell A1. A1 B1 CHI090169094 BKG# 19802749 BKG# 19802749 CHI090114574 BKG# 18133600 CHI090122224 BKG# 16469485 Thanks, Sonia |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to cut part of a text from one cell and automatically paste it onto another cell
Right(a1,13) should get you there.
HTH Regards, Howard "Sonja" wrote in message ... Hello, Please see below example: I have column A1 which has information CHI090169094 BKG# 19802749 and I want to extract BKG# 19802749 and put it into column B1 and delete the information that was in A1 for BKG# 19802749. Can someone advise how I can do this. I tried using the formula =LEFT (A1, 13) and it captures CHI090169094 and pastes into B1 column. But That's not what I'm looking for. I would like for the formula to capture BKG# 19802749 from A1 and put it into column B1 and delete the information that was copied from cell A1. A1 B1 CHI090169094 BKG# 19802749 BKG# 19802749 CHI090114574 BKG# 18133600 CHI090122224 BKG# 16469485 Thanks, Sonia |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to cut part of a text from one cell and automatically pasteit onto another cell
Howard,
Thanks that helps me get the text and insert it to B1 but once I get the text I want to remove it from A1. Can you advise what other function I need to add to it. Tks, Sonia On Aug 17, 4:33*pm, "L. Howard Kittle" wrote: Right(a1,13) should get you there. HTH Regards, Howard "Sonja" wrote in message ... Hello, Please see below example: I have column A1 which has information CHI090169094 *BKG# 19802749 and I want to extract BKG# 19802749 and put it into column B1 and delete the information that was in A1 for BKG# 19802749. Can someone advise how I can do this. I tried using the formula =LEFT (A1, 13) and it captures CHI090169094 and pastes into B1 column. But That's not what I'm looking for. I would like for the formula to capture BKG# 19802749 *from A1 and put it into column B1 and delete the information that was copied from cell A1. A1 * * * * * * * * * * * * * * * * * * * * * * * * *B1 CHI090169094 *BKG# 19802749 * * *BKG# 19802749 CHI090114574 *BKG# 18133600 CHI090122224 *BKG# 16469485 Thanks, Sonia- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to cut part of a text from one cell and automatically past
Sonja,
You can not use a formula to overwrite the data it is using. YOu would need vba code to do this. All you could do is put Right(a1,13) in B1 to get BKG# 19802749 and left(A1,12) in C1 to get CHI090169094. Hope this helps "Sonja" wrote: Howard, Thanks that helps me get the text and insert it to B1 but once I get the text I want to remove it from A1. Can you advise what other function I need to add to it. Tks, Sonia On Aug 17, 4:33 pm, "L. Howard Kittle" wrote: Right(a1,13) should get you there. HTH Regards, Howard "Sonja" wrote in message ... Hello, Please see below example: I have column A1 which has information CHI090169094 BKG# 19802749 and I want to extract BKG# 19802749 and put it into column B1 and delete the information that was in A1 for BKG# 19802749. Can someone advise how I can do this. I tried using the formula =LEFT (A1, 13) and it captures CHI090169094 and pastes into B1 column. But That's not what I'm looking for. I would like for the formula to capture BKG# 19802749 from A1 and put it into column B1 and delete the information that was copied from cell A1. A1 B1 CHI090169094 BKG# 19802749 BKG# 19802749 CHI090114574 BKG# 18133600 CHI090122224 BKG# 16469485 Thanks, Sonia- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to cut part of a text from one cell and automatically paste it onto another cell
DataText to ColumnsFixed Width.
Drop a split at the first space. Assuming your data is consistent as your example. Gord Dibben MS Excel MVP On Mon, 17 Aug 2009 14:24:53 -0700 (PDT), Sonja wrote: Hello, Please see below example: I have column A1 which has information CHI090169094 BKG# 19802749 and I want to extract BKG# 19802749 and put it into column B1 and delete the information that was in A1 for BKG# 19802749. Can someone advise how I can do this. I tried using the formula =LEFT (A1, 13) and it captures CHI090169094 and pastes into B1 column. But That's not what I'm looking for. I would like for the formula to capture BKG# 19802749 from A1 and put it into column B1 and delete the information that was copied from cell A1. A1 B1 CHI090169094 BKG# 19802749 BKG# 19802749 CHI090114574 BKG# 18133600 CHI090122224 BKG# 16469485 Thanks, Sonia |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to cut part of a text from one cell and automatically paste it onto another cell
Try this...
In a column use Left(a1,13) In another adjacent column use Right(a1,13) Now copy the two columns and Past Special Values OK back into column A and B. Regrds, Howard "Sonja" wrote in message ... Hello, Please see below example: I have column A1 which has information CHI090169094 BKG# 19802749 and I want to extract BKG# 19802749 and put it into column B1 and delete the information that was in A1 for BKG# 19802749. Can someone advise how I can do this. I tried using the formula =LEFT (A1, 13) and it captures CHI090169094 and pastes into B1 column. But That's not what I'm looking for. I would like for the formula to capture BKG# 19802749 from A1 and put it into column B1 and delete the information that was copied from cell A1. A1 B1 CHI090169094 BKG# 19802749 BKG# 19802749 CHI090114574 BKG# 18133600 CHI090122224 BKG# 16469485 Thanks, Sonia |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to cut part of a text from one cell and automatically pasteit onto another cell
On Aug 17, 5:28*pm, "L. Howard Kittle" wrote:
Try this... In a column use Left(a1,13) In another adjacent column use Right(a1,13) Now copy the two columns and Past Special Values OK back into column A and B. Regrds, Howard "Sonja" wrote in message ... Hello, Please see below example: I have column A1 which has information CHI090169094 *BKG# 19802749 and I want to extract BKG# 19802749 and put it into column B1 and delete the information that was in A1 for BKG# 19802749. Can someone advise how I can do this. I tried using the formula =LEFT (A1, 13) and it captures CHI090169094 and pastes into B1 column. But That's not what I'm looking for. I would like for the formula to capture BKG# 19802749 *from A1 and put it into column B1 and delete the information that was copied from cell A1. A1 * * * * * * * * * * * * * * * * * * * * * * * * *B1 CHI090169094 *BKG# 19802749 * * *BKG# 19802749 CHI090114574 *BKG# 18133600 CHI090122224 *BKG# 16469485 Thanks, Sonia- Hide quoted text - - Show quoted text - Thanks you all for your help. That will work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy selected part number of text from one cell into another cell | Excel Discussion (Misc queries) | |||
| un-Bold part of text in a cell (automatically) | Excel Discussion (Misc queries) | |||
| How do I include part of a cell in text (string?) in another cell? | Excel Worksheet Functions | |||
| Using Text from one cell as part of a cell reference in another | Excel Discussion (Misc queries) | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
![Sonja[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
