LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rich0072
 
Posts: n/a
Default how do I convertext in cells a1, a2, a3 and covert to a1, b1, b2

I have addresses which were entered in cells a1, A2, A3 and so On and I need
to convert them to appear in cells a1, b2, b3 I know I have performed this
function in the past but I am drawing a blank please help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
covert Cellular phone dec to hex tom g Excel Discussion (Misc queries) 2 November 21st 05 09:31 AM
Formatting Cells Paul Excel Discussion (Misc queries) 2 September 7th 05 05:37 PM
Converting a link to values to multiple cells. Cesar_us Excel Worksheet Functions 1 June 22nd 05 09:37 PM
How does excel automatically covert cells when a different number. talil Excel Discussion (Misc queries) 1 March 17th 05 06:49 AM
How to covert old Lotus 123 files with .123 extension to Excel? Kate Excel Discussion (Misc queries) 2 January 31st 05 06:51 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"