Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.