| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel copy data
Hi,
Say your data is in range C3:C10. In D3, enter the following formula and then copy down till D10 =IF(ISNUMBER(C3),LOOKUP(REPT("z",99),$C$3:C3),"") There copy D3:D10 and paste them as values. After this, you may delete the text entries in C3:C10. Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Paul Gardiner" wrote in message ... Hi I have a file like this aaa 12 113 14 bbb 25 12 58 alpha is the customer name and numbers are stock items purchased. all in one column How do I get aaa to appear next to 12,113 and 14? and bbb to appear next to 25,12 and 58? EggHeadCafe - Software Developer Portal of Choice ASP.NET Asynchronous Page Processing http://www.eggheadcafe.com/tutorials...nous-page.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How copy none excel data & paste in 2007 without overwriting data | Excel Discussion (Misc queries) | |||
| copy outlined data in excel | Excel Discussion (Misc queries) | |||
| Copy excel data (inc. textbox data) into Word | Excel Discussion (Misc queries) | |||
| Copy data from one Excel spreadsheet to another | Excel Discussion (Misc queries) | |||
| how Excel can copy the data in a row of worksheet to other? | Excel Worksheet Functions | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
