LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Steve M
 
Posts: n/a
Default input text at front of field that contains data

Hi there,

I have imported data into excel and I wish to input text ZZ in front of the
orginal data...for example her is how the data looks like(to the left).

Column A (how do I put a ZZ in front of the text without going through it
one by one
________ so in a matter of seconds it should look like this(the column to
the right)
ABADES ZZABADES
ABADEF ZZABADEF
ABADET ZZABADET
ABADER ZZABADER
ABADEW ....and so on
....and so on

I have 6211 rows to input "ZZ" infront of the original text...what is the
fastest way to do this? Please Help

cheers
Steve M
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create excel spreadsheet to display data from filled text forms pluck4me Excel Discussion (Misc queries) 0 April 20th 05 08:37 PM
How do you transfer data from an input form in excel to an excel l mdalzell Excel Discussion (Misc queries) 0 April 18th 05 06:10 PM
Multiple worksheet queries liam Excel Worksheet Functions 3 February 16th 05 06:52 PM
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Pivot Tables..I give up... Debutante Excel Worksheet Functions 4 January 21st 05 10:43 PM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"