Posted to microsoft.public.excel.programming

Saintsman

external usenet poster

Posts: 81

if cell is text move left one column

ColB is a long list with sections names followed by category codes
I need to move the text into colA leaving colB with codes only (all numbers)
ColB.
Doors
940590
555998
447006
447008
810697
810705
810706
810707
Windows
619435
525691
525692

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
Move curser left one cell	Patrick C. Simonds	Excel Programming	2	May 14th 08 11:43 PM
if cell text repeats, move the adjacent column to the same row	ILoveMyCorgi	Excel Programming	5	April 8th 08 11:06 PM
How do I Move column A, B, etc. to left side.	TeesPlus	New Users to Excel	1	February 24th 06 07:32 PM
Getting Range to move 1 column left and resize by 1	mozart[_4_]	Excel Programming	1	August 24th 05 08:39 AM
move y-axis labels on column chart from left to right side	Kaye	Charts and Charting in Excel	3	June 3rd 05 12:59 PM

All times are GMT +1. The time now is 07:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us