My good 'ol formula for inserting text isn't working!!

[David in VB]

Hi all,

Previously, I obtained this formula from someone on this site and it worked
fine. Now, I'm having problems:

I’m trying to insert the words “for the purposes of†in front of the name of
everyone in the G. I did this successfully before by creating a spare
column. I used the formula =â€assignee of “&G2 and then copied down. This
time, no go. It just displays the formula in each cell of the column. Any
advice? Thanks!

 

[Sprinks]

David,

I believe the cells are formatted as Text. Change them to General before
entering the formula.

Sprinks

 

[Pete_UK]

It sounds like the cell is formatted as text. With the cell selected, click
on Format | Cell | Number tab and choose General, then click OK. Then
double-click the cell as if to edit it and press <Enter>, to cause the
format change to take effect. Then you will be able to copy the cell down.

Hope this helps.

Pete

 

[David in VB]

Sprinks,

That fixed it!!! Thanks!

David,

I believe the cells are formatted as Text. Change them to General before
entering the formula.

Sprinks

 

[David Biddulph]

You've presumably got the cells formatted as Text. Format as General, then
re-enter the formula.