Replace with total - ExcelBanter

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1

Replace with total

Hello all,
I have in Column A customers that have a * and two extra
spaces.These customers that contain such thing is the
total for that customer . Example,
Column A
* Test Tech
* tech is this

Is it possible to replace the *Spacespace to Total?Exa,
Total Test Tech
Total tech is this

If I do the Find Replace, it will cause some errors
because of the * and space.
Please advise any help.
Thanks,
Juan

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
Duplicate Running Total Grand Total In Pivot Table	Mathew P Bennett[_2_]	Excel Discussion (Misc queries)	1	August 17th 08 03:13 AM
WHY DO HASHES REPLACE NUMERICAL TOTAL	trevor	Excel Discussion (Misc queries)	3	May 1st 08 05:56 PM
Excel 2002 : Any single button to get sub total and grand total ?	Mr. Low	Excel Discussion (Misc queries)	2	May 22nd 07 08:46 AM
find and replace - replace data in rows to separated by commas	msdker	Excel Worksheet Functions	1	April 15th 06 01:00 AM
Adding Data Using Multiple Worksheets to Total into a Grand Total	Lillie	Excel Worksheet Functions	1	April 19th 05 08:34 PM

All times are GMT +1. The time now is 05:36 AM.

Menu

About Us