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
Bookmarks