Note Generator

[sbryan]

Hi guys!

I'm quite new to excel so I have just this very quick question.
Here's the situation:

The first line of the text in A8 is from B4.
Would that be possible?

Screenshots:
carda.JPG
------------------------------
carda1.JPG

Thank you so much!

[Crooza]

If you just want to extract the "Andrew Jones" from the message (in b10) and providing you always start with a name in your message then this will extract the name

=left(b10,find("%",substitute(B10," ","%",2)))

[alansidman]

In A8 =B4 & "Your Additional Text Here inside quotations"

[Crooza]

If you just want to extract the "Andrew Jones" from the message (in b10) and providing you always start with a name in your message then this will extract the name

=left(b10,find("%",substitute(B10," ","%",2))

Or if you want to ADD to the "Andrew jones" in B4 then

= b4 & "your text here "

[sbryan]

Ooohh, I am too dumb not to try that one out

Thank you so much for the replies, indeed you guys reply so fast