Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel 2002


  • Please log in to reply

#1
jaxisland

jaxisland

    Member 1K

  • Member
  • PipPipPipPip
  • 1,703 posts
I have a spread sheet with 1000's of lines of info. I want to add a @ to the beginning of each cell. So right now I have cells with:
1
2
3
4...

I want it to be:
@1
@2
@3
@4...

Is there a way I can add that automatically without going through each cell. This is in Excel 2002.

Thanks
  • 0

Advertisements


#2
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
In the first cell (A1), type '@1

In the second cell (A2), type '@2

Highlight both cells

Grab the handle at the bottom right of the highlighted cells and drag down as far as required.
  • 0

#3
jaxisland

jaxisland

    Member 1K

  • Topic Starter
  • Member
  • PipPipPipPip
  • 1,703 posts
It works, thank you very much.
But how come I have to use '@ and cant use just @
  • 0

#4
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
Excel sees @ as a special symbol. Adding ' before the @ makes Excel see the @ as text instead of a special symbol.

HTH
  • 0

#5
jaxisland

jaxisland

    Member 1K

  • Topic Starter
  • Member
  • PipPipPipPip
  • 1,703 posts
Crap. The file is an output from a server in a .txt file. I open in Excel to make these changes, but then I need to import the file back into the server, so I cant have the " ' " symbol.

Any suggestions?
  • 0

#6
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
Highlight cells A1 and A2
Right-click in the highlighted area > Format Cells > Number Tab > Text > OK
Type @1 in cell A1
Type @2 in cell A2
Highlight cells A1 and A2
Grab the handle at the bottom right of the highlighted cells and drag down as far as required.
  • 0

#7
jaxisland

jaxisland

    Member 1K

  • Topic Starter
  • Member
  • PipPipPipPip
  • 1,703 posts
Ok I had this:

1
2
3
4

Then I did this:
enter @ 1
enter @ 2
enter @ 3

Highlighted the three cells, grabbed the bottom right corner and dragged down, but instead of adding "enter @" it just overwrote all the cells with "enter @ 1" then 2 then 3 and repeats. How do you get it to add to the cell instead of overwriting?

Thanks
  • 0

#8
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
I'm confused!

You said you had:

1
2
3
4

You said you wanted:

@1
@2
@3
@4

and that's what my instructions will do.

If you want:

enter @ 1
enter @ 2
enter @ 3 and so on.... then the instructions still work.

Do you want something different?
  • 0

#9
jaxisland

jaxisland

    Member 1K

  • Topic Starter
  • Member
  • PipPipPipPip
  • 1,703 posts
I apologize for the confusion, I switched half way through. Let me start over so I dont confuse you anymore. My fault.

Ok, I have a list of email domains in excel:

123.com
12a.com
abc.com
a1b.com

In the end I need two seperate files from this list, the first one to be:

@123.com
@12a.com
@abc.com
@a1b.com

The second on to be:

msExchTurfListNames: *@123.com
msExchTurfListNames: *@12a.com
msExchTurfListNames: *@abc.com
msExchTurfListNames: *@a1b.com

The problem I have been seeing is if highlight the first three and then drag with the bottom right corner, it overwrites everything with the first three I selected.

Again sorry for confusing :whistling:
  • 0

#10
jaxisland

jaxisland

    Member 1K

  • Topic Starter
  • Member
  • PipPipPipPip
  • 1,703 posts
Here is what I did to resolve this. I downloaded the trial version of Insert Text from Black Knight Software. Used that to insert the @ symbol in front of everything.
Saved that file.
Then just used Excel's Find and Replace to replace the @ with msExchTurfListNames: *@
Saved that as a different file.

Thanks for the help!
  • 0

#11
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
Glad you got it sorted :whistling:
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP