Add info from a cell with a specific value

**scoopster** · 02-19-2009, 05:47 AM

I have text information that i need to arrange in an issuable format. Unforunitaly the cells change when the data is pasted in.

For exampe if i have 2 parts of informatin being

Name: Tom
Surname: Jones

Is there any forumlas that let able you to search a column for in this instance "name:" and place the value of that cell into the forumla cell!

Example

Cel C1 = Name: Tom
Cell C2 Surname: Jones

Cell A1= Formula searches Column C for Name: Finds Cell C1 and Places "Name: Tom" in cell A1

Thanks in Advance

**martindwilson** · 02-19-2009, 07:07 AM

there are various ways of doing this sort of thing, depending on how exactly info is presented/laid out , attach a sheet with a few on ,
problem with searching /matching though is it'll only ever find first name if 2 are the same.
e,g if its always in c starting c1 no spaces
tom
smith
fred
bloggs
eric
cartman
then in a1
=INDIRECT("C"&ROW()*2-1)
and in a2
=INDIRECT("C"&ROW()*2)
dragged down will give
tom smith
fred bloggs
eric cartman

**scoopster** · 02-19-2009, 08:10 AM

May be best i give some background to what i am trying to do. I am in the process of opening an online shop. The Cms System that has been provided to me provides me with a text output for each order. I am looking to set up an Excel Template so that i can simply copy and paste and excel will duplicate the info i require to create a despatch note etc.

The text information is as follows

Name: Tom
Surname: Jones
Email: [email protected]
Address1: Dunhill Road
Address2: Bridge Farm Road
City: Uckfield
County: East Sussex
Postcode: TN22 5AL

Problem being is that although this pastes the details in a common column the row numbers change from time to time depending what has been entered
Ideally i would like to enter a forumla into another cell to duplicate what is in each of the above. if the search was set up to search "name:" in that cell would be "Name: Tom"

It doesnt matter that the descriptions are included i have another forumla which will remove a set number of charactors at the start or end. But the end product will just be the persons name and address.

Please see Attached Excel Spreadsheet for more info.

Thank you for your time and your help.