Hi new here and with excel could use some help thanks in advance

[gtsjeff]

ok here is what im trying to do in my excel sheet i have 157 rows and in column E some cells are occupied with a name the others are blank i would like to find a formula that would say if the cell in column E has a name in it add the word "and" to it with a space after "and" i would like it to do the whole column any help would be greatly appreciated thanks new to this

Jeff

[Craig K.]

So as to not violate the forum rules, you need to rename this thread to something more descriptive than "need help." The thread title needs to be something that can easily be searched for.

Next, you need to throw some punctuation into that run on sentence. It's hard to decipher what you're asking for. The more descriptive and easier it is to read, the better we will be able to assist you. For example, look at how some other threads and how the users post their questions.

[etaf]

is this in a another cell or overwriting the existing - if over writing - you need a macro - not my area

if another Cell - say column F

=IF( E1<>"", E1&" and " , "")
this adds and after the name with a sapce before and after
OR if you want it before the name
=IF( E1<>"", "and "&E1 , "")

copt down the 157 rows

[arlu1201]

Thanks Craig.

Gtsjeff,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Jakobshavn]

Say you are using rows #1 thru #157. Try this small macro

Please Login or Register  to view this content.

[gtsjeff]

Such a very nice welcome from you Craig! I am in crunch time for work project, sorry I didn't meat your standards. I see you just came on to hassel the new guy asking for help without helping at all. I feel so welcome.

[gtsjeff]

jakobshavn thanks so much for the macro. I really do appreciate it, like I said I am new to excel and have no idea where to place that macro for it to work.

[Jakobshavn]

Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I

ALT-M opens a fresh module

3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.
If you are using a version of Excel later then 2003, you must save
the file as .xlsm rather than .xlsx

To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To use the macro from Excel:

1. ALT-F8
2. Select the macro
3. Touch RUN

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Macros must be enabled for this to work!

[arlu1201]

gtsjeff,

Did you read post 4?

[gtsjeff]

jakobshavn .....you rock!!!!! the and was after my name so I switched the rvalue and the and around and it works perfectly thank you so much i have like 9 doc's to use this on ...have a great weekend jakobshavn

[Richard Buttrey]

Hi,

Look, I really don't want to get heavy over this....but...

@gtsjeff

There's no need to be sarcastic with Craig he's only pointing out the rules and this rule about Titles is probably the most important.

@jacobshavn
@etaf

As senior members you really should know better. Are there any extenuating circumstances since at face value you are both due an infraction.

[Jakobshavn]

Hi Richard:

I already apologized to Arlu (offline).
Following the rules is important.