Excel Question - Find and Replace

[Mr Pickles]

Hey there, I have a list of computers in a column and I'd like to enter a space at the end of each computer name. There is no similarity in any of the computer name, so I'm having a hard time with the Find portion because I'm not sure what to tell excel to look for. Here's an example:

Computer Names:

Bob13
Eliza2
ControlRoom
ConfRoom
Petuna-XP

I simply just want to put a space at the end of each of them. So obviously my Replace will be just a space. So what do I use for the find? I tried using * and * * but it will just wipe out the whole field.

Any ideas? Thanks...

 

[NeoV]

find and replace would only work if you had multiple computers with the same name

easiest way is to put this formula in column B

=A1&" "

Then copy-paste special - value

 

[Mr Pickles]

Originally posted by: NeoV
find and replace would only work if you had multiple computers with the same name

easiest way is to put this formula in column B

=A1&" "

Then copy-paste special - value

What?

 

[mayest]

Yes, NeoV has the right answer. That formula will concatenate a space onto the end of the string in A1. Then, copy that down so that it works on each string. Finally, copy the range of formulas and then do a Copy --> Paste Special --> Values on top of your original strings. Then you can delete the formulas that you entered.