Too much data in a single cell. How to search/output specific data from each cell?

[effang]

Hi. From mySQL database, i am getting a ton of data that is all being inputted into a single excel cell. Within this cell, there are certain data points that i wish to obtain (Bank #, SSN #, Routing #). There are multiple difficulties in obtaining this information.

1. these cells contain the same fields, but different number of total characters (differing in names, addresses, etc.)

2. some of the data points (like SSN) are inputted incorrectly, so even though a SSN is only 9 digits/characters, I may have to output all 11 that the SQL database placed within the cell.

Can I get some help? I'm thinking of a search function/macro within excel, because all of the fields show up correctly.

something like (i know this doesn't work)

= or("cellA1" contains/finds/function SSN,return the 9 characters after "SSN ")

um...yeah. difficult to explain, i'm sorry!

[keithl816]

You need to read the rules on posting the same question on other sites.

http://www.ozgrid.com/forum/showthre...d=1#post362234

[VBA Noob]

Thanks keithl816,

effang,

I've locked this post. If you agree to the rules below then PM me and I'll unlocked the thread.

VBA Noob