Solved How to extract only similarly formatted data

Microsoft Office 2003 professional oem
October 28, 2011 at 12:24:14
Specs: Windows XP Pro
I have an Excel spreadsheet challenge that I can use some help resolving. I have multiple rows of similar data within one cell where I need to extract only the similarly formatted data from each cell to be saved as a new document. I have considered using Find and Replace formulas, but I am unsure how best to proceed. Any and all help would be appreciated.

Current spreadsheet cell contents:

On 05/18/11 at 1125 hours, asdjasdjasdjfajsdfjasd
On 07/2/11 at 1645 hours, sdofigjsdfisdufgsndfo
On 09/14/11 at 2218 hours, poksdpofmwlermeme
On 10/28/11 at 0822 hours, iqweryqwuesmnsmdf

Desired spreadsheet cell contents:
On 05/18/11 at 1125 hours
On 07/2/11 at 1645 hours
On 09/14/11 at 2218 hours
On 10/8/11 at 0822 hours


See More: How to extract only similarly formatted data

Report •

#1
October 28, 2011 at 13:01:54
✔ Best Answer
I'm not sure what you mean by "similarly formatted data".

Typically, in Excel at least, formatting refers to things like Bold, Font Size, cell fill pattern, etc.

Do you mean that you want to extract all of the text up to the comma? If so, try this:

=LEFT(A1, FIND(",", A1) -1)

LEFT(text, num_chars)

The LEFT function will return the left-most characters of the text argument, based on the value of the num_chars argument.

In the formula I suggested, the value of the num_chars argument will be determined by the FIND function. FIND will look for the position of the comma in A1 and then subtract 1 from that position.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
October 28, 2011 at 13:53:01
@DerbyDad03 ... perfect solution to my problem! I am by far not an Excel guru and your answer just saved me a TON of work. Thank you for all your help and the quick reply.

Report •
Related Solutions


Ask Question