|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)
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.