#11

Posted to microsoft.public.excel,microsoft.public.excel.misc

Herbert Seidenberg

Posts: n/a

Lining up data from concatenation

Not a bad thought.
Just do the formatting inside the formula.
=CONCATENATE(TEXT(A1,"0000")," ",B1)

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
Pull data from another sheet based on certain criteria	steve_sr2	Excel Discussion (Misc queries)	1	February 23rd 06 10:08 AM
Importing Data	Jillian	Excel Worksheet Functions	9	December 23rd 05 12:45 PM
From several workbooks onto one excel worksheet	steve	Excel Discussion (Misc queries)	6	December 1st 05 08:03 AM
Saving data in a worksheet within a workbook	Homeuser	Excel Discussion (Misc queries)	2	August 21st 05 10:49 PM
Line Graph Data Recognition	Nat	Charts and Charting in Excel	2	April 30th 05 02:07 PM

All times are GMT +1. The time now is 08:40 AM.

About Us

"It's about Microsoft Excel"