Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have exported address information from Quickbooks to an Excel spreadsheet
and need to know how to do the following to split out the info into other cells. The Text to Columns feature doesn't look like its going to help. Here's what I need: 1) Find and include everything up to the third space (" ") from the left 2) Include all information starting from the first number from the left to the first comma from the left Many thanks for your help. -- David P. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract a specific portion of text as new cell value | Excel Discussion (Misc queries) | |||
Extract text in middle using Mid and Find or Search | Excel Discussion (Misc queries) | |||
HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE | Excel Worksheet Functions | |||
extract number and use in formula from text & numbers in cell | Excel Worksheet Functions | |||
formula to extract partial content (text) of cell | Excel Discussion (Misc queries) |