| 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 |
| 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)
Threaded Mode
