Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jaycain
 
Posts: n/a
Default Add data to cell w/o loosing initial data

I would like to know if there is a way to add data to data without retyping.
For example I have a colum of 18015555555 and I want to add [rfax:(cell
#)@/fn=(phone number)] So I would like to add the brackets - copy from a
cell - @/fn= and not loose the data already in the spread sheet. Example 2.
Add [rfax:company name@fn/=(saved data here) then close bracket.

So I want to add data to cells without loosing the data already in the
cells. I have about 600 of them to do and I really don't want to do each one
by hand.

Please let me know if anyone knows how to accomplish this.

Thanks
  #2   Report Post  
Myrna Larson
 
Posts: n/a
Default

Assuming the phone number is in B2, the word "Company" in A2, you can create
the text you want with this formula ="[rfax:"&A2&" name@fn/="&B2

Copy this down as far as needed. To convert the formulas to their values,
Edit/Copy the formulas, then Edit/Paste Special over the formulas or in a new
column, selecting the VAlues option.

On Mon, 28 Mar 2005 17:01:03 -0800, "jaycain"
wrote:

I would like to know if there is a way to add data to data without retyping.
For example I have a colum of 18015555555 and I want to add [rfax:(cell
#)@/fn=(phone number)] So I would like to add the brackets - copy from a
cell - @/fn= and not loose the data already in the spread sheet. Example 2.
Add [rfax:company name@fn/=(saved data here) then close bracket.

So I want to add data to cells without loosing the data already in the
cells. I have about 600 of them to do and I really don't want to do each one
by hand.

Please let me know if anyone knows how to accomplish this.

Thanks


  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

You could try

="[rfax:company name@fn/=("&A1&")"

or


="[rfax:company name@fn/="&TEXT(A1,"(00000000000)")


the latter will give you a better way of formatting it as a phone number for
instance

="[rfax:company name@fn/="&TEXT(A1,"([<=9999999]###-####;(###) ###-####)")

--
Regards,

Peo Sjoblom


"jaycain" wrote in message
...
I would like to know if there is a way to add data to data without
retyping.
For example I have a colum of 18015555555 and I want to add [rfax:(cell
#)@/fn=(phone number)] So I would like to add the brackets - copy from a
cell - @/fn= and not loose the data already in the spread sheet. Example
2.
Add [rfax:company name@fn/=(saved data here) then close bracket.

So I want to add data to cells without loosing the data already in the
cells. I have about 600 of them to do and I really don't want to do each
one
by hand.

Please let me know if anyone knows how to accomplish this.

Thanks



Reply
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
Import Data into same cell ib_redbeard Excel Discussion (Misc queries) 3 March 1st 05 01:08 PM
I want a window to cell data that conains links to PDF files and . WEATHER TECH. NOT A ROCKET ENGINEER Excel Discussion (Misc queries) 1 February 24th 05 09:21 PM
How do I change a cell so I can have the data it contains in seve. swede Excel Discussion (Misc queries) 1 February 21st 05 07:22 PM
Repeat Cell Data Pinky Excel Worksheet Functions 1 January 18th 05 06:38 PM
Retrieve last cell with data JimDandy Excel Worksheet Functions 2 November 20th 04 07:50 PM


All times are GMT +1. The time now is 01:46 AM.

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

About Us

"It's about Microsoft Excel"