Extract the middle line of data from a single cell with multiple lines in it?
I have a list with this type of information in each cell on the left column of my spreadsheet that looks like this
Company A Incorporated
333 anywhere St
city name, STATE 12345-1111
I need to be able to grab all of this information and separate it out into different columns like this
Column A Column B Column C Column D Column E Column F
Company A Incorporated 333 anywhere St city name state 12345-1111 555-222-3333
Does anyone have any ideas?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1