| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving cell data and separating or deleting
In cell A1 I have YWCA. In cell A2 I have 012345 and (101) 452 1234. These are respectively an account name, account number and phone number. As the end result I'd like to have YWCA in column A. The account number and only the account number in Column B. I'd like to delete the phone number. The data isn't all in a neat row..Here's a sample: YWCA 0584377 (9 04) 727 YWCA OF JAX/COMMUNITY CON 0584378 (9 04) 35 0- ZABATT, INC 05873 03 (9 04) 384- ZAPA MANAGEMENT INC/ADULT 0588299 (9 04) 42 ZAXBY'S C/O ST JOHN & PAR 05883 05 (9 04) 281 ZENITH MEDIA/NESTLE 0588531 (212) 85 ZZ MAC, INC 05872 02 (9 04) 46 Any help would be appreciated. -- jonhunt ------------------------------------------------------------------------ jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370 View this thread: http://www.excelforum.com/showthread...hreadid=551403 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separating text and data in a column | Excel Worksheet Functions | |||
| coma not separating data | Excel Discussion (Misc queries) | |||
| Separating information in one cell into several cells | Excel Discussion (Misc queries) | |||
| Separating data in a cell | Excel Discussion (Misc queries) | |||
| Separating data ( 1 time range) in one column | Excel Worksheet Functions | |||
Threaded Mode
