Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the following text in a cell that i want to concatenate to another cell.

Pre-Condition: 1. ABC 2. ABC 3. ABC 4. ABC


I want to extract the following text:

Pre-Condition: 1. ABC 2. ABC 3. ABC 4. ABC

I tried using a macro by seaching two newline characters, but it is not working. Please suggest i have loads of data that I need to perform this task.

share|improve this question
It could be due to the formatting or the way your question is phrased, but I don't know what it is you want. Please show the data you have and how the data should look afterwards. If you want to format text in mono-space, just add 4 spaces at the beginning of each line. Here is more information on formatting. – Robert Ilbrink Mar 12 '13 at 10:47

you can use the following formula =LEFT(A1;FIND(" ";A1))

assuming A1 the cell containing your data

for the first parameter of FIND function type ALT-ENTER on the keyboard, enclosed by "

regards michel

share|improve this answer

The formula will look like this in Excel :


share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .