Excel/excel return part of cell
QUESTION: I have information listed as a date, name, and amount in a single cell. I used LEFT and RIGHT statements to return just the date and amount. Is there a way to have just the name returned?
i.e. 05/13/12 Frontier, IN 45.62
I want to transfer into three different cells as 05/13/12, Frontier, IN, and 45.62
ANSWER: IF you actually need to split out the data, data, text to columns would be the easiest route as this physically breaks up the data. If it has to be done with formulas, then the MID function would do it It gets a little messy though - to get Frontier (if the data starts in A1)
and to get the IN
[an error occurred while processing this directive]---------- FOLLOW-UP ----------
QUESTION: I do not have to use formulas just did not know of an alternate method. Not sure what you mean by data, text to columns. Would you explain?
Sorry, in excel prior to 2007 version, it's the menu choices data, followed by text to columns - you would need to select the data first, then use that choice. In 2007 onwards, click the Data tab and then click the Text To Columns command in the Data Tools group.
You need to ensure you have enough blank columns to the right of your data to take the data - otherwise existing data will get overwritten - if it is only one column of data that shouldn't be an issue, otherwise just insert columns.
I hope this has clarified things but if you need any further help or clarification just let me know.