Quickie Excel question

[Darren S]

I'm in the process of uploading the mobile phones onto our phone switch so it displays a name on the incoming calls, rather than just a mobile number.

I've got a full list of names and numbers in an Excel 2003 spreadsheet, but I'd like to add the word 'Mobile' at the end of everyone's name e.g 'Darren Smith Mobile' 'Joe Bloggs Mobile', etc.

Can anyone tell me how to do it en masse, or do I have to manually add the word 'Mobile' over 150 times!

I've looked at Find & Replace, but I'm not actually replacing anything....

Cheers,
D.

 

[Rob Clark]

can only think a macro. record edit cell, return, go to next cell end record. then press the button for the macro 150 times which does all the editing

 

[JackoR26]

Try using the CONCATENATE function

 

[MickeyO]

naw

just go to google

download "asap utilities"

install it.

it adds asap to your tool bar at top

add a colum next to your name and fill it with "mobile" all the way down

select both columns and then go to asap, columns, merge column data.

you can then select how many spaces to put between the words once merged

asap is free as well

 

[JackoR26]

naw

just go to google

download "asap utilities"

install it.

it adds asap to your tool bar at top

add a colum next to your name and fill it with "mobile" all the way down

select both columns and then go to asap, columns, merge column data.

you can then select how many spaces to put between the words once merged

asap is free as well

Nice, never heard of that before

 

[@Spoonie]

Pretty much the same as doing this thats in the help:

http://office.microsoft.com/en-us/excel/HP030561251033.aspx

 

[cava83]

use a splice system?

Not too expensive and really good !

 

[Darren S]

Cheers for the comments guys!

I remembered the CONCATENATE function as soon as jacko mentioned it. Tried it and it worked - spot on.

I'll check that ASAP Utils out though, Mick - sounds useful.

Cheers!

D.

 

[MarkCup]

Once you've used the CONCATENATE function, make sure you copy and 'paste special' the results as 'values'...or any subsequent copy or use will just be copying or using the formula, not the text result you're after.

 

[Darren S]

Once you've used the CONCATENATE function, make sure you copy and 'paste special' the results as 'values'...or any subsequent copy or use will just be copying or using the formula, not the text result you're after.

Lol - yep! Tried the Paste function on it's own and got bollox on screen. Then tried it with Values only....

Just downloading those ASAP Utilities now - may as well have a butchers at them...

D.