HELP ME PLEASEEE- how to format data in a column

Posted to microsoft.public.excel.misc

Riza

Posts: n/a

HELP ME PLEASEEE- how to format data in a column

I have like 5000 different data and I need to add letter ab in front of them.
Could anyone tell me how to do this.

for example 123 is what it says but I need ab123 and each row is different
number.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Need to Improve Code Copying/Pasting Between Workbooks	David	Excel Discussion (Misc queries)	1	January 6th 06 03:56 AM
Positioning Numeric Values Resulting from 6 Column Array Formula	Sam via OfficeKB.com	Excel Worksheet Functions	2	January 5th 06 02:03 AM
Column format when merging Excel data to Word labels	Red	Excel Discussion (Misc queries)	1	April 6th 05 03:40 AM
Pulling data from 1 sheet to another	Dave1155	Excel Worksheet Functions	1	January 12th 05 05:55 PM
Can you average data in 1 column based on a range of values in another?	kman24	Excel Worksheet Functions	2	November 17th 04 02:09 PM

All times are GMT +1. The time now is 06:32 PM.

Menu

About Us