Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

PQRSTUV

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
1  
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
add comment

2 Answers 2

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
add comment

The formula will look like this in Excel :

=LEFT(A1;FIND("

";A1))
share|improve this answer
add comment

Your Answer

 
discard

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.