Posted to microsoft.public.excel.worksheet.functions

Muthalaly

external usenet poster

Posts: 5

Concatenation in Excel

Hi,
I am trying to concatenate two fields in excel.In this one field is a cutom
number field .When I am doing the concatenation I am losing the zeros before
the number.
Example 00123 + abc I am getting a result of 123abc .But I am looking
forward to get 00123abc. Is it possible in excel?Please help.

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
Concatenation	orquidea	Excel Discussion (Misc queries)	6	January 11th 08 07:19 PM
Concatenation in Excel 2003	lireland	Excel Worksheet Functions	7	November 9th 07 12:40 AM
Concatenation	Sol	Excel Discussion (Misc queries)	5	October 23rd 07 08:03 AM
Concatenation using IF AND - Possible?	Col	Excel Worksheet Functions	3	April 30th 05 01:22 AM
Excel needs to expand text concatenation capability	Steve Schultz	Excel Worksheet Functions	4	March 21st 05 10:39 AM

All times are GMT +1. The time now is 11:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us